Does anyone know a way to validate the results of a stored procedure? I have a routine that checks for updates to procedures and validates the format of the data returned but the only way I can do that is to dump the results to a temp table. I can't insert into a temp table […]
2004-11-12
1 reads
When trying to export data from a table to a flat text file, I am suddenly encountering a failure, with the error message stating that the transaction log of tempdb is full and it needs to be backed up.I'm using the DTS wizard to create the export, the data is being pulled from one table, […]
2004-06-17
2 reads
How large your log backup typically from 9PM to 9AM without performing database shrinking?DBCC SHRINKDATABASE moves the data and index pages within the database files and such activites should be logged for recovery purpose.
2004-01-08
NO, it's actually being started under the domain Administrator's login.
2003-12-11
2 reads
that is a good idea. The only think that I would do ..instead to recover in the same PC I would recover in different one because the memory and CPU will be affected when you run DBCC ...so that will affect the live database try that the chanses to have an DB corruption in live […]
2003-11-14
Well done Frank. All that hard work's paid off. What are you going to do when they find out you're spending most of your day solving other people's problems... and you've been awarded EOTM by 27 other companies around the world? Cheers, - Mark
2003-08-21
1 reads
If anyone needs it here is a sample of how to use the where clause. You simply use double quotes. SELECT * FROM OPENQUERY(UNDERWRITING,'SELECT * FROM RS_INV03 where memb_num="01804-00"')
2003-08-21
2003-08-08
quote: What difference does it make if the rights are explicit? The user still requires them. Yes and no. We can go into the semantics about whether or not a user requires them or not. Really it's a point that there's no reason to argue about. Every login has access to master. Even if I […]
2003-07-14
Well im not writing it for you ... but check these objects out: mydb..sysmembers: contains a row for each member of a database role master..syslogins: hooks to mydb..sysusers over the sid column master..sysdatabases: loop for all these Cheers Ck Chris Kempster www.chriskempster.com Author of "SQL Server 2k for the Oracle DBA"
2003-07-10
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