Hi, I run a query on SQL SERVER 7.0 (select+inner join+left join) on a couple of tables (one of them has 25 milions tuples) as sp in a job and everytime I run this job I get blocked process in msdb db. Any ideas? Thanks in advance.
2001-09-05
5 reads
Hi all, I've made SQLMail send mails to my Exchange server and Outlook2000. But, my corporate is using Lotus. How do I send mails to my corporate mailboxes. Thanx in advance Parasu Parasu Raman
2001-09-05
2 reads
Dear Listers, I imagine that many organisations operate with SQL7 on W2K, and that someone has already gone through the task of investigation. I have read that this is not an ideal combination. Is anybody able to provide personal experience or direction to documentation that details potential problems. Thanks In Advance John
2001-09-04
6 reads
We backup the the trans logs hourly on a SQL 2000 server. The size of a particular trans log dump done at Sunday 9pm, was 94KB. This is typical. But one hour later at 10pm, the same trans log dump had a size of 317,368KB! The business is closed on Sunday, expecially labor day weekend. […]
2001-09-04
2 reads
Can we use any kind of activex object in SQL server stored procs. I have used CDONTS component to send mails from SQL Server. I know there is xp_sendmail in sql server to send mails. But what if I create my own activex control. Can I use it. And how? Paras Shah Evision Technologies Mumbai, […]
2001-09-02
13 reads
How can you Execute a DTS Package from an StoredProceedure?
2001-09-01
2 reads
I've created this procedure to count the number of times a particular condition was met in a log file. CREATE PROCEDURE SP_SMTPSTATS AS DECLARE @TEST AS INT SELECT @TEST = COUNT (*) FROM smtpstats Where clienthost = "10.0.0.64" AND Operation = "Data" AND bytesrecvd > 200 AND bytesrecvd < 2000 ??????????????NOW WHAT???????????????????????????? GO Now I […]
2001-08-30
2 reads
hello there, i have written a trigger for the city table. whenever a user enters a value in it it will check whether the city is new or old, if its new then it should allow it to enter the new value, but its not working here is the code : create trigger keyurtrig11 on […]
2001-08-29
4 reads
I'm trying to find the percent of free disk space from a t-sql script so I don't run some operations and blow up the server due to out of disk space errors. I'm stumped. Wes
2001-08-29
166 reads
Hello, Could some one please tell how to get the current Identity value from a table using Dynamic sql. My code is listed below. declare @qry nvarchar(500) declare @qry1 nvarchar(500) declare @tabName nvarchar(50) declare @x int set @tabName='tblCenters' set @qry = N'select @ident=ident_current('''+@tabName+''')' set @qry1 = N'@ident int' exec sp_executesql @qry, @qry1,@x print @x It […]
2001-08-28
5 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers