Viewing 15 posts - 35,611 through 35,625 (of 39,720 total)
You cannot update multiple tables in one statement. You'd need 3 statements to update all 3. You can update one table that is joined to 2 others, but the updates...
December 6, 2003 at 2:00 am
I don't think this much matters from the server perspective. It isn't checked anywhere. It's more a legal item that you purchase the licenses in case you are audited.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
December 6, 2003 at 1:59 am
Thanks for the complement!!!!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 5, 2003 at 6:57 pm
You will be able to code a VB.NET procedure, using .NET constructs inside SQL Server. These are compiled and execute. However, for many query type statements, this won't make sense...
December 5, 2003 at 1:38 pm
Congrats!!!! and thanks for being a part of the community.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 5, 2003 at 1:35 pm
Wow, is that from v6.5? It's been awhile, but I thought you couldn't shrink those files.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 5, 2003 at 1:34 pm
You can work this by pulling in data and updating it based on which data from customerData is already in the data mart. I've done something similar (I think) where...
December 5, 2003 at 1:33 pm
We don't like cross posting. I tend to delete the one I see second (or third). Makes things more confusing.
Honestly, most of our regular people use the "Active Threads" link...
December 5, 2003 at 1:31 pm
Great idea! We're looking at redoing the forums (and the site along with it), so I'll pass this along to the guys doing the work.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
December 5, 2003 at 1:29 pm
Anytime, glad it worked.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 3, 2003 at 9:47 am
Works fine for me (see ALTER). SQL 2K, SP3a, Personal.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 3, 2003 at 9:34 am
The log file consists of a bunch of logical files and if one of those is active, you cannot shrink below it. There is a script in our lbrary that...
December 1, 2003 at 2:26 pm
Build a DTS pacakge and roll everything up into one server.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 1, 2003 at 2:21 pm
From what I understand, above 8GB, you need to leave the OS 1GB for PAE.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 1, 2003 at 12:05 pm
There are some scripts in our script library that can do this.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 1, 2003 at 11:54 am
Viewing 15 posts - 35,611 through 35,625 (of 39,720 total)