Viewing 15 posts - 39,301 through 39,315 (of 39,501 total)
I understand trying to remove connections if there are licensing issues, but otherwise, I agree with Andy. Why kill an idle connection. They use tens of kb of memory and...
October 3, 2001 at 9:53 am
OK, OK, I'm awake. BTW, I'm not that lazy, I just live in Denver.
OK, I think that a UDf would be great for calculations. they really make things easier to...
October 3, 2001 at 9:49 am
October 2, 2001 at 10:23 am
This is an interesting thread. My 2cents:
I think the production dba will continue to exist in larger shops. Even with the advances and ease of administering SQL Server 2000, quality...
October 2, 2001 at 10:18 am
there are a bunch of ways. is this a scheduled job? Add a step before that uses a CommandExec and a "del filename". you could also add a step to...
October 2, 2001 at 9:46 am
This is corect. All the changes in SQL are considered a single transaction if this is one statement. This would be an implicit transaction.
Steve Jones
October 1, 2001 at 10:15 pm
October 1, 2001 at 10:13 pm
September 28, 2001 at 9:05 pm
Here are a few links:
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/tips/storagen.asp
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/tips/storagen.asp
Steve Jones
September 28, 2001 at 8:35 am
xp_cmdshell - takes rights of the SQL Server service. This means that the command is executed as if the SQL Server Service account logged into the server, opened a command...
September 25, 2001 at 11:15 am
I see this occassionly on my W2K/SS2K server. Actually I had it the last two nights. The server is across a slow link fro the domain and it seems to...
September 25, 2001 at 10:31 am
September 25, 2001 at 9:47 am
My 2 cents:
1. I'd have the user "submit" a request to create dbs. You can then have someone create the db (or automate this).
2. I'd give the users logins, and...
September 25, 2001 at 9:46 am
I usually see this error when my T-SQL code does something "illegal" in SQL. Like a divide by 0 (thought I think that actually throws a reasonable error).
Recheck the SQL...
September 25, 2001 at 9:34 am
Where are you getting this? EM or QA or somewhere else?
You might have some network problems.
I'd try it from the local console of the server and see what happens. You...
September 25, 2001 at 9:24 am
Viewing 15 posts - 39,301 through 39,315 (of 39,501 total)