Hi,

Thanks for your replies. I already use the registration grouping feature to run queries against multiple servers. My query relates to running a command against a registration group...

Great,

Ok when i change to the user DB and run the helpuser account i get data back. However, when i go to run the following :-

use USERDB

GRANT EXECUTE...

Great,

Ok when i change to the user DB and run the helpuser account i get data back. However, when i go to run the following :-

use USERDB

GRANT EXECUTE...

Ahh great.

The message is :-

The name supplied (User) is not a user, role, or aliased login.

Does this help?

Hi,

Thanks for your advice. I changed the username I'm logged on with and tried again. The message "Cannot find the user 'PostOptApp', because it does not exist or you...

Hi,

I removed said components from the script and remarkbly the process work correctly.

Many thanks for you help!.

Hi,

Thanks for your reply. To confirm this is SQL 2008.

The procedure is the same as the first submission, a simple drop and recreation of the date data type....

Hi Jeff,

I split out the file into four segments and loaded it into Excel. I could then filter out the formatting characters until I found the row with illegal characters.

A...

The issue is now resolved.

Thankyou all for you assistance.

Hi,

Thankyou all for your replies. I have imported the file into a seperate table and have noted the error.

It would appear that carriage returns are causing the issue,...

Adam,

Thanks for the reply. I need to keep the structure but set all the data in some columns to null whilst leaving the data in other columns

Hi,

I would like to find the time difference between column B Eg 24/07/2007 17:55 and column A 24/07/2007 14:29.

Thanks,

Hi,

Here's the table

CREATE TABLE

(

[SHIFT] [char] (6) COLLATE Latin1_General_BIN NOT NULL CONSTRAINT [DF___OPERATOR__2A90068A] DEFAULT (''),

[END_DATE] [smalldatetime] NOT NULL CONSTRAINT [DF___END_DATE__23E308FB] DEFAULT ('1900-JAN-01'),

[END_TIME] [int] NOT NULL CONSTRAINT [DF___END_TIME__24D72D34] DEFAULT ((-1)),

[OPERATOR]...

Spot on .... Thanks.

HI,

They field one is varchar, field two is int.