Viewing 15 topics - 269,476 through 269,490 (of 283,921 total)
Topics
Started by
Posts
Last post
How to find the no concurrent users in a database and on a server using T-SQL but not using sp_who.
2 replies
I have been dabbling with MSSQL Server and T-SQL for about two years now. I would like to be at lea…
4 replies
Hi! I use this query: select min(l.ACCTDESC), g.ACCTID, sum(TRANSAMT) fromlegacy..GLPO…
3 replies
Hi all, I am getting some problems with the query,, The query is talking a long time to execute.. I…
2 replies
Hi Does anybody have any scripts to check if an agent job is still running? i.e if job is running …
3 replies
Hi The job I've linked to an alert got stuck. I manualy stoped the job, now it gets launched on and…
4 replies
Anyone know if there is a way to access the actual text of a stored procedure from the system table…
3 replies
Dear All, I am trying to write a sp which on error will capture the error in a declaration. However…
3 replies
I have 16gb in 190 DB's running on 2 xeons w/ 2gb RAM. Same query against same db on a differenct …
6 replies
Sometimes when i edit my records in EM i get error of Firehose Pls suggest
1 replies
Hi, I have a procedure to calculate the number of work days in a period of time (don't count saturd…
3 replies
Hi folks, I would like to pass a table into my sproc as a parameter.No joy, I know that I can use …
5 replies
ANY RAPID REPLIES APPRECIATED! Working with SQL Server 2000, Visual Basic 6.0 (with ADO): I've cre…
3 replies
I have a job step which is an ActiveX type, although the script will execute correctly as a standal…
5 replies
I have a SS2K database that I run the maintenance plan optimizations on every weekend. lately, whe…
6 replies
Viewing 15 topics - 269,476 through 269,490 (of 283,921 total)