SQL Server Tools

Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools. Who is affected? You are affected if you use SQL Server 2005 maintenance plans, those plans ...

I've got a job that has 3 lines and it reports success after it runs. DELETE FROM TABLE1 WHERE DATE >= '20070115' DELETE FROM TABLE2 WHERE DATE >= '20070115' DELETE FROM TABLE3 WHERE DATE >= '20070115' I then have a separate job for each line below which imports from another ...

I have a scheduled job for a DTS package and was reviewing the history, but it only keeps 50 events listed in the history. Is there any way to expand this or a query that can be used to extract more history about the executed ...

Hi All, I'm using Visual Web Developer 2005 Express Edition and Microsoft SQL Server Express Edition.  I have a database which was originally created using SQL Server 2000 that I'm using in an ASP.NET application.  I can open the database just fine and use it in the ...

Hi, I setup my SQL 2000 Server to use C2 auditing.  It is working. My only problem is that my trace file does not get populated while I am inserting/updating/select data or anything. However, when I stop SQL server then my trace file gets populated. ...

Good Afternoon Everyone, I hope everyone is doing GREAT today.  I've got a database where my customers First and Last name are in ONE field (ContactName), and we are upgrading to another SQL application that actually has (2) seperate fields, ...

Hi, I never had this issue in the "text" results pane of SQL Server 200, but when I save the "text" results in SS2005, the results end up with UNICODE encoding. I then have to open the file in Notepad, do a "File->Save As", changing the ...

I have a view in SQL2000 that when I am in QA and drill down the columns using the + signs no columns show in 2000.  If I use SSMS and drill down in the same way the columns do show. ...