quote: ...Is there any possibility that DBCC is trying to fix some minor errors, and SQL Server changing to Single User Mode & not changing it back?! Just a Thought.... That is EXACTLY what is happening. When you check "Attempt to repair minor problems" under the Integrity tab, the maint plan job will try to […]
2003-07-30
What's your version for Ms OLE DB Provider for Oracle? Also SQL Version
2003-07-23
1 reads
This article assumes that XML is the way of the future, which is a false assumption. XML has some significant problems. 1. Performance. I'm not talking about file size (and the resulting poor performance over networks), but about that fact that parsing XML is an intensive process. For one thing, you must read the entire […]
2003-07-21
Now why did I not think of that. Sounds a very straightforward solution compared to the hoops I was trying to jump through. Running the job every minute is clear and also the logic to process the tables. Just a couple of points which are not quite clear to me in your reply: When you […]
2003-07-02
There is an option in Backup Exec (I've never used the option myself, so check out your documentation) to restore to a different location; it's similar to SQL Server's WITH MOVE. -SQLBill
2003-06-30
A real low-tech way would be similar to the method mentioned by stax68. Create a stored procedure to do the work. Set it as a job to run every minute (or whatever frequency seems necessary). The arguments indicating that the process should be run would be entered into a table from your calling program. When […]
2003-06-27
Replication is enabled for specific databases and should not effect how the others operate. However, depending on push or pull an where the distributor is they can chnge the server loads which does effect overall performance. And DTS is not the same as replication although you can create a custom datamove similar to the concept […]
2003-06-27
Thanks for your input I realized the problem...I had to also include the Dbname.table.columnname in the where clause..
2003-06-26
1 reads
I tried it a again: use master exec xp_cmdshell 'bcp "select * from dbname.owner.table where checkbit = 0" queryout e:\products.txt -c -Sserver -Usa -Ppassword' I get as an error the format for writing bcp commands...?
2003-06-26
You could try select * from master..FGMapperPageAlloc where dbid = 6 and fileid = 1 and charindex(ObjectNameAtPage,@vmyobj_) > 0 order by 1,2 Sorry, typo. Edited by - davidburrows on 06/24/2003 07:41:11 AM
2003-06-24
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