Viewing 15 posts - 35,656 through 35,670 (of 39,771 total)
It cannot find the SQL server. Are you sure you have the name correct and it is running?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 6, 2003 at 12:24 pm
correct, it appears the identity is not part of the transaction. The main reason is that if someone else were to run this with you, you wouldn't want them to...
December 6, 2003 at 12:22 pm
that's what it says, a network error. That being said, can you parse (not excute) the statement?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 6, 2003 at 12:20 pm
Did it install with no errors?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 6, 2003 at 12:16 pm
Lightspeed also has encryption in their product if you are really worried. Most of the data in the backup file is ASCII text. While it can't be "restored" without the...
December 6, 2003 at 2:02 am
I do it like Dinesh suggested.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 6, 2003 at 2:01 am
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
Viewing 15 posts - 35,656 through 35,670 (of 39,771 total)