Here is a Microsoft article that gives you some ideas.

http://msdn.microsoft.com/en-us/library/ms187445.aspx

I thought it might be a permission issue at first but we are using windows autenticated and I am and admin so that should not really be an issue.

Ah well I suppose we could use a veiw but this seemed like a proper use for a synonym. Excel has a check box to show synonyms so it...

The motivation comes from the overly generic names used by the thir party software. For example the table structure looks something like this.

Bi001

Bi002

Bi003

Now thoise tables are actually the account...

No good reason other than just have not got around to testing it with the product on the server. This is a mission critical server so it takes alot...

If you are creating a report through SSIS I would recommend creating the report through SSRS and then setup a subsrciption for the report.

Open the SQL Server configuration manager and right click on the agent and selct properties. In the properties window you will find the login informaiton. this is also...

I would say that the answer is yes the User group likely granted access to the Service account that SQL Server Agent starts on. you may not have to have...

For anyone who is interested or looking into this we did the upgrade this weekend and the older client laptops where able to replicate with out any problem to the...

In you first example you are lookin at all records in TableA as such if a records does not exist in TableB then a NULL is returned. In the...

The following scripts would place the entire contents of the current errorlog into a temp table.

CREATE TABLE ##Errors1 (ERRORLOG varchar(8000),continuationRow varchar(5))

INSERT into ##Errors1

(ERRORLOG,continuationRow)

Exec master..xp_readerrorlog

I can not get to the file you uploaded as the site is blocked on my work network. Can you paste the SQL code that is used?

While there are much easier ways of doing this through enterprise manager in 2000 you can do this in TSQL using a combination of sysobjects and sysindexes. you would...

when you allow multiple values the values are stored and passed as a string pretty much no matter what you do. If you select 1,2,3 while each value may...

I am not entirley sure you can use an or in an IIF in that way. try removind the second clause and see if that takes care of the...