Visual Studio will actually create the batch files for you if you create a database project and have a folder you want to script the files for. I use this...

First off can you do any distributed transactions with the linked server?

Also is one of your servers running Win2003?

If you have a Win2003 machine try the following...

open Component Services...

While using the "All" keyword will seem to do what you want a more reliable solution would be something like the following...

select CategoryID, CategoryName, 1...

I can think of 2 different approaches I would take in this situation.

1. Split this into two separate sp calls. One to give you if the record exists and a...

I know I'm a bit late in this but you should have been able to simply do something like the following....

 

SELECT datepart(mm,date_requested) as my_month

...

Also, to make the field case sensitive you can use the COLLATE clause on the field...

 

IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('foo'))

...

Dealing with the nulls is actually fairly simple. Try something like the following...

SELECT ISNULL(field1 + char(9),'') + ISNULL(field2 + char(9),'') + ISNULL(Lastfield,'') as DelimittedString

Since a null added to anything...

I don't know of any way to do this. Can I ask why you want it?

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

I'm guessing it has to do with your datafiles being located in a different location on the new server. Try running the following script in query analyzer on the new...

quote:

---

The Company I am working for has tow locations 250 Km Apart

(One Central (H.Q.) And One Remote)

The Sites are connected with a...

Linda,

Antares stated it best. What I always do is use a script that is kept in a source controlled environment to change any of my database objects. In this way...

Depending on the types of things you are doing in the database you should be able to use the Dev edition on your local machine. I've been doing that for...

First I would read the Readme file included with SP3a. It should have the command line you need to use to install SP3a. If not try looking at the following...

http://www.microsoft.com/sql/downloads/2000/sp3.asp

Gary...

Depends on the default SQL Server collation used. If you specify a default collation when installing SQL Server of Latin1_General_Bin you will have the usernames cap sensitive because all your...

For this type of problem I typically use a UDF. The one I'm providing here will return a table for each record. If you are only using it for a...