Viewing 15 posts - 286 through 300 (of 498 total)
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 8, 2003 at 6:44 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 4, 2003 at 8:37 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 4, 2003 at 8:07 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 4, 2003 at 7:53 pm
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
...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 5:22 pm
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'))
...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 4:45 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 4:12 pm
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
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 4:04 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 3:35 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 3:28 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 3:08 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 2, 2003 at 3:04 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 18, 2003 at 4:54 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 17, 2003 at 7:31 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 17, 2003 at 7:21 pm
Viewing 15 posts - 286 through 300 (of 498 total)