2012-10-16 (first published: 2012-09-21)
2,281 reads
Create a folder
RE: DTS Errors
You probably do not have the privilege to execute jobs on the server. Change the resulting job ownership to a login that has execute job permission after you schedule the DTS package.
2004-01-06
Deletign a log file: Urgent
Here is the situation. The Transaction log backup failed repeatedly over time the log began to consume the drive. This basically brought down the server because the transaction log was full. I added a second log file on a different drive and then performed a backup, truncated and shrunk the log file.I now want to […]
2004-01-06
3 reads
XP_CMDSHELL Results Question
I am using the following script to attempt to obtain a file list from a mapped drive. (The drive is mapped from a UNIX Box) Drop Table Reuseable.dbo.tblDir Go Create Table Reuseable.dbo.tblDir ( dirtext nvarchar(255)) Go Insert Into Reuseable.dbo.tblDir exec master..xp_cmdshell 'dir p:\' Go Select * From Reuseable.dbo.tblDir RESULTAccess deniedNULL What am I doing Wrong??
2004-01-06
2 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers