Search results for query: *

I need advise on refining our backup/restore process. We have a big honkin' production database that needs to be backed up, BAK copied to 2nd server, then restored on 2nd server for Endmonth processing. Currently the backup/restore time is quite lengthy. It is my understanding that I can...

I have inherited some T-SQL code and I keep running into JOINs with delayed ONs. Much of the code was generated by the graphical Query Designer. I found this example in BOL FROM clause -> FROM clause (described): Can't this be written as What's the purpose of the delayed ON criteria between...

I am trying to learn how to work with Service Broker. I've found several examples, the simplest was from SQL Server Central: http://www.sqlservercentral.com/columnists/sSampath/anintroductiontotheservicebroker.asp The example runs successfully, but doesn't return the message from the queue...

I was recently told that I should truncate a table before I drop it. The thought was dropping a table logs data being removed from the table but truncating doesn't. This doesn't sound right to me. I thought that in both cases only the deallocation of pages is logged. I can't find anything that...

I have been tasked with creating a DTS package that uses ActiveX scripts to create another DTS package. I need to create a Dynamic Properties task in the target package. I have successfully created the task object, but cannot create a reference to the object's Assignments collection. I have...

I was told recently that SQL Server can read an index in forward and reverse order. For a single column index, its simple enough. 1,2,3 can be read 3,2,1. But what about multi-column indexes? I was told SQL Server can read an index's columns in reverse order. So an index built on State then...

My boss just got the beta version of SQL 2005. He wants to install it on a box which currently has SQL 2000 running. Are there any known issues with doing this? Does anyone have any advise, cautions? Thanks all. --John [rainbow] ----------------------------------- Behold! As a wild ass in the...

Brain cramp! How can I write to the DTS package log from an ActiveX script? I have done so in the past, but now I can't for the life of me get the syntax right. --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock...

I have the query below (in blue) that will act as a derived table in a larger query. If I run it, I get the expected record set. However, when I use it as a derived table (by wrapping it in the red text), I get the error below. Server: Msg 913, Level 16, State 8, Line 1 Could not find database...

I have a DTS package that is scheduled to run on the 2nd of each month. The main package runs several other packages to FTP, import, and transform data into SQL Server. This process has run successfully for 3 months until now. The scheduled job's history shows the job failed immediately on...

Is there a limitation with the Dynamic Properties task that will not query a text file connection? I keep getting the error No such interface supported. I have scanned BOL and can't find anything regarding this problem. Any ideas? --Angel [rainbow] ----------------------------------- Every time...

SQL2K sp3 I have a DTS package that I am running from a stored procedure using the sp_OAMethod OLE automation stored procedure. The stored procedure doesn't capture a package failure correctly. If I'm reading BOL correctly for sp_OAMethod, it returns "0 (success) or a nonzero number...

This is the strangest thing I've ever seen - well, recently anyway. I have an FTP Task that downloads five files from a remote location. Four of the files have a TXT extension, the fifth has a CSV extension. The four TXT files download without a problem. The final CSV file seems to download...

Just curious who's going to New Orleans next week for the SQL Connections conference? I'll be there for the conference and staying a few days extra for myself. Lots to learn and lots to see. [cheers][deejay] --Angel [rainbow] ----------------------------------- Every time I lose my mind, I...

I have the following SELECT that uses a derived, pivot table. I am pivoting a normalized table on the fly. When run, I am receiving the following error message. What does this mean? How can a table have more columns than * (all columns)? Server: Msg 8158, Level 16, State 1, Line 2 'aoi' has...

I am using sp_post_msx_operation to synchronize the time on my servers, but I am having problems. One server syncs just fine, but the other gives this error message: The specified @specific_target_server ('WRLive') does not exist. Both of the target servers are configured the same as far as I...

We are using XML embedded in our stored procedures to document the functionality, etc. of the stored procedure. The XML is in a comment block so as not to interfere with the procedure. Here's a sample: /* <ROOT> <Author>Me</Author> <Created>December 2002</Created> <Revisions> <Author...

I am working on metadata that uses two tables: Properties table PropertyName IsDefault ------------------------------ Source Y Description Y MetaData table ObjectName PropertyName PropertyValue...

I need to put a trigger on the SysUsers table to email me when users are added or modified. I found the code I thought I needed: sp_configure 'allow updates', 1 Reconfigure With Override GO That should allow me to apply the trigger, but I still get a &quot;permission denied&quot; error...

I need to be able to track changes to object permissions on my server. My first thought was to create triggers for SysUsers and SysProtects to log the changes and then schedule a nightly task to select logged changes that happened that day and email me. But, of course, it isn't possible to...