Viewing 15 posts - 35,671 through 35,685 (of 39,771 total)
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
To clear the log file, you need to run a "backup transaction dbname with no_log", not delete it. Can you restore the file? (ldf)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 1, 2003 at 11:51 am
Have you checked the error logs? Perhaps there was an issue loading one of the logs.
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:41 am
The saving data locally is something in the application, correct? It's not a SQL or Access thing AFAIK.
In SQL this will not occur automatically, the application would have to handle...
December 1, 2003 at 11:40 am
Shouldn't be unicode. Is your server setup for Unicode? What code are you running to get the Unicode results?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 26, 2003 at 10:33 am
Good question. I'm not sure. Everything I've seen on CALs is based on the types of connections. If you're completely internal, I don't think that you need to buy per...
November 25, 2003 at 5:28 pm
Not that I know of, but I bet you can generate an install file using setup by running through the unattended install process and selecting only the client install.
Search "How...
November 25, 2003 at 5:20 pm
The only way I know of is to actually sniff the network. You can see the result sets from Query Analyzer and I'd be extremely surprised if there were malformed...
November 25, 2003 at 5:19 pm
no
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 25, 2003 at 5:17 pm
For small business edition, I think it's Standard since clustering, log shipping, etc. don't seem to be supported.
For IIS usage, client licenses are required if your clients that connect are...
November 24, 2003 at 9:58 am
Viewing 15 posts - 35,671 through 35,685 (of 39,771 total)