Hi,If it helps - yes you can do away with cursors and still step through everything:- SET @PK = (SELECT MIN(PK) FROM #Values) SET @MaxPK = (SELECT MAX(PK) FROM #Values) WHILE @PK <= @MaxPK BEGIN--Do whatever you are doingSET @PK = (SELECT MIN(PK) FROM #Values WHERE PK > @PK) ENDThough i'm not too certain what […]
2004-11-02
Hi,What is the best strategy for backing up my SQL data to tape using Veritas? a) Backup the transaction logsb) Use the Veritas sql agent to backup the data directlyThank you, Victor...
2004-11-01
2004-10-27
Hi Kenneth,Thanks for the reply. The problem i have is, there will be a multiple contact nos selected from the input parameter. All the contact nos will use in the WHERE clause to select records from TableC and return the result. The contact no selected from table B can be 3 and up to 16 nos.How this can be […]
2004-10-22
What about traces? You can set up a trace to log your logins specifying NTuserName and LoginName and also a DatabaseName or DatabaseID field in the Data Columns for the events Audit Login and Audit Logut or Audit Login Failed. It could be done by running a script, so it would run without Profiler being open […]
2004-10-13
DBAs,Does anyone know of other hot standby solutions for SQL Server besides failover clustering? Are there any 3rd party tools available?Thanks.
2004-10-01
1 reads
This was posted on the BugTraq security mailing list and has made a Secunia vulnerability announcement. Here is the announcement: TITLE: Microsoft SQL Server Denial of Service Vulnerability SECUNIA ADVISORY ID: SA12680 VERIFY ADVISORY: http://secunia.com/advisories/12680/ CRITICAL: Less critical IMPACT: DoS WHERE: From local network SOFTWARE: Microsoft SQL Server 7 http://secunia.com/product/8/ DESCRIPTION: securma massine has reported […]
2004-09-30
3 reads
Hi folks. I have not seen the following before: I cannot add the security group ‘domainname\LADM SLEEC DEV’ as a login to SQL Server which complains that the group does not exist. If I use Enterprise Manager and attempt to add the user, I can see that the group does indeed exist in the domain… Now, […]
2004-09-27
Scheduled subscriptions are just SQL Agent jobs. You could just change the time on the jobs, but that may have other consequences within the RS database. Another option would be to knock up a quick .net app that uses the web service to modify the times.
2004-09-16
Exactly. The question should read "over 2 billion objects". The thing the documentation doesn't indicate is whether or not that includes the system objects. I guess when you are talking about billions, a couple hundred don't matter. Just curious though.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
2004-09-03
I recently received a complaint that Query Store for a particular database was turned...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
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