Viewing 15 posts - 35,701 through 35,715 (of 39,771 total)
sp_dropserver tmp-prod
sp_addserver prod, local
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 12:25 pm
shouldn't
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 12:25 pm
I don't recall this being mentioned with Yukon. MS has seemingly gone back to the "scale up" strategy. There was a vendor that was building hardware boxes that would split...
November 20, 2003 at 10:35 am
It's really up to you. The tools will always be on the C drive unless you hack the registry. It doesn't really matter where the program files are stored since...
November 20, 2003 at 10:32 am
That's what I thought. I'd guess PSS can help you, but there would be a charge.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 10:27 am
Wow, great question. I'll try to dig around a little, but my impression is that these are fired like this:
check constraint
rule
PK
FK
trigger
Rules are an old feature, only one per column and...
November 20, 2003 at 9:43 am
Does the data file get created and populated?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 9:35 am
Does best equate to most "quality" posts as determined by Brad?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 9:33 am
I think this practice is a bad idea. If your file gets corrupt or you have some issue, you could lose a bunch of backup data. Personally I like the...
November 20, 2003 at 9:32 am
Not really sure. Most likely a PSS call. Have you tried opening these in notepad or Excel and seeing if you can make some sense of it?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
November 20, 2003 at 9:28 am
set @cmd = 'exec GetEORepsByRA' + cast(@ID as char)
exec xp_sendmail ....., @query=@cmd
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 19, 2003 at 9:56 am
try a select * from the table and see if you get all rows. Also try rebuild a clustered index or change the clustered index to another column. That will...
November 19, 2003 at 9:52 am
you can use the command line version of pkzip to do this. See the program for switches. If you want a component and object model, then you probably have to...
November 19, 2003 at 9:48 am
You need to grant access to the objects to other users. The dbo gets it by default.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 18, 2003 at 4:18 pm
Electronics were thought of, but economics plays a part in this as well. We may still do a pdf publish, but no promises.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
November 18, 2003 at 4:17 pm
Viewing 15 posts - 35,701 through 35,715 (of 39,771 total)