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
Suppose our SQL server is doing a database backup and at that very moment a browser program attempts to update the database. Is the user change "held" and later captured by the backup or is it missed until the next trans log dump? TIA, Bill
2001-08-28
4 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
27 reads
The company I work for has recently decided to use Source Safe on all of our DTS packages. To do this we save the package down as a .dts file and check it into SS. We've ran into a bump in the road though. When saving as a .dts file, we lose all of the […]
2001-08-27
3 reads
I have table A with three fields. Emp_Code Char(3), Emp_Name varchar(15), Policy_Change_Date datetime GetDate() . If any one record changes in table A, i wish to get the system date into the Policy_Change_Date. How will i create this trigger?
2001-08-27
2 reads
Every once in a while the SQL ServerAgent (SQL 7) stops unexpectedly. How can I use DMO to check if the service is running, and better yet, to notify me, if it fails? TIA, Bill P.S. I have selected the "Autorestart Agent" option but it doesn't work reliably.
2001-08-24
8 reads
I'm new to SQL and Stored procedures. I'm trying to write a stored procedure and I'm having difficulty with the syntax. Ultimately what needs to happen is that if a certain condiion is met, then a variable will add one to it's initial value of 0 until the procedure has gone through the table basically […]
2001-08-23
1 reads
I am trying to find a report writing tool (like BRIO), that also allows users to update lookup tables. Is there any products that allow this? Thanks Joe
2001-08-23
3 reads
I have 2 SQL 2000 SP1 installations and when I am in Ent. MGR, database, taskpad, table info all tables say they have zero rows when this is not the case, the size in K for the tables does appear to be correct. I have auto stats update option on the database and I used […]
2001-08-21
5 reads
Hello, I am trying to write the output of a stored procedure to a txt file. I am unable to find any technical matter on the same. can anyone help me in this regard. I want to call that output txt file from a ASP page later. Thanks
2001-08-21
310 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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