Since yesterday, new subscription will not fire. However old subscirpitons are still running as scheduled. Any ideas? Thanks.
Hello, I want to save the XML output into a table but apparently the following didn't work (also menitoned in the BOL). insert#tmp select*...
I don't see the option of exporting to .txt. Can I?
Hello, Can i export to text file from DTS with header and footer? What I am looking for is: MyFileName20050901 Data1, Data2, Data3, Data4, Data5...
Hello, once in a while, our application will receive timeout error. When I was being notified by the users (a few minutes later), everything already...
SQL Log printed the following two messsages. I wonder what they are.... Thanks! Using 'odsole70.dll' version '2000.80.194' to execute extended...
Hello, I am confuse. I got a notification email today regarding my backup job: JOB RUN:'Backup Job' was run on 11/25/2003 at 10:00:00 PM DURATION:2...
Hello, I back up log every two hours from 5:45am to 11:45pm by creating a Maintenance Job. Since 3 days ago, the job failed at 3:45, daily, with...
hello, I need to concatenate results from different rows with the same ID. I only know how to this via Cursor, just wondering if there is a better...
For some reason, the sa password in our server is being changed all the time. How can I track it? Thanks!
Hello, how can I show all the SPs that referencing a particular table? These include Update, Delete, Insert and Select (including in the Join)....
Hello, I am moving data from production to report server nightly. I am just wondering what is the best way to do it. Option 1: - Truncate Table -...
Hi, I want to change from System account to Domain account, however, the Startup Service Account section is dimmed? What should I do?
One of the users can connect to Server A from SQL Analyzer with NT Authentication, but fail to connect to server B. However, everybody else can...
I use Error 1222 to detect deadLock, unfortunately, the Alert didn't fire. How should I set up the Alert so that it would fire when deadlock...
I used DBCC Reindex to defragment my indexes. Here is the result for the clustered index: - Scan Density [Best Count:Actual Count].......: 99.60%...
Deadlock occurs in our server at least once a week. I captured the information with Trace and Profiler. We have a program that do the select on...
Separate names with a comma.
