Microsoft SQL Server Administration

I have SQL Server 2005 Express. Using Microsoft SQL Server Management Studio Express, I'm trying to delete or update a record in a table. I get the following message: "Data has changed since the Result pane was last retrieved. Do you want to ...

Hey all, I have a site that has their log file at 40 gig (running SQL Server 2005). The database is set to FULL recovery model, and transaction log backups are performed every 3 hours. The log file is HUGE compared to usual and I need to shrink it down. ...

Hello all.  I am currently running the following setup. -Windows Server 2003 Enterprise Edition (32-bit) -4 x 2.5 ghz Xeon Processors -12 gigs of Ram (with /PAE switch enabled) -Static 4092mb page file -SQL Server 2000 sp4 Enterprise (8.00.2040) ...

Running SQL 2000 with a Linked Server to Sybase using Microsoft OLDE DB Provider for ODBC and having some sporadic problems with the following: select * from openquery(LINKEDSERVERNAME, 'select * from dbname.tablename') If we run this using query analyzer from a desktop client using Windows Auth ...

Hey guys, I have a Microsoft SQL 2005 database server that I renamed after migrating databases over from an old SQL 2000 server.  There is an old maintenance plan that was created before the server name change.  When I try to delete it, I ...

Does anyone have an example of an update statement using intercept?  I'm trying to do an upsert (update existing, insert new) and I can't get the syntax for the update statement using intercept.  I can do the insert using ...