Microsoft SQL Server Administration

Hi, I am thinking about buying a laptop that I'll use for development also, my question is: Is it possible to install sql server on Vista Home Premium, as it seems big chains load their laptops only with that Vista version? ...

I want to do paging with my VB.NET app using SQL Server.  I have a large table with over 5 million records.  I've read numerous articles on how to page using TOP, ROW_NUMBER and OVER , etc.  I've tried the ...

SQL Server 2000 Standard Edition I would like to monitor which stored procedures are being used so I can delete (archive) ones that are no longer being used. I was thinking of running SQL Profiler and having it monitor just the Event Class SP: ...

Each time I test the email in SQL Server 2005 it goes into a queue.  The mail works fine in SQL 2000.   There are about 25 emails in the queue and no amount of configuring or dropping the DBMail accounts seems to be able to get ...

I know that nobody supports 6.5 any more, but we still do have some production servers on this version. Application is old, and not supported any more, so we are not sure if it would work with the new version of sql server. ...

Still working with this SqlDependency idea, but have not been able to successfully muddle through it. I'm using David Sceppa's sample from Ch. 14 (ADO.Net 2.0) to set up a sample DB with SqlDependency working. The script ...

All, I'm trying to test sending mail using SQL Server 2005. I have configured database mail but I'm getting the following error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 10 (2007-02-13T12:38:53). Exception ...

Creating a utility that will allow a user to run a query from a BAT file. BUT the SQL client is not installed on all PCs.  How can I modify this to run, or what must I do in order for this to work from PCs with no SQL client ...

I am running SQL 2005 SP1 Enterprise Edition on a clustered environment for several months now. Over the last few weeks, the server has been crashing with memory errors, see below. Nothing has changed SQL Server related, but we have been applying security patches to the OS. The OS is Win 2003 SP1. One ...

We use a hosted SQL Server database on a remote server for our web site. Is there a stored procedure I can run that will give me the spec of the remote windows server? Just things like CPU, RAM etc. ...

Hi, I need to take data from a SQL Serer 2005 database, and load into a remote 2000 database.  I've already been able to script and create the database objects (MS SQL Server 2005 has a nifty option which allows ...

Hi Everyone, About 2 months ago i have noticed that my sql database backup has been failing with the following error: BACKUP failed to complete the command BACKUP DATABASE [databasename] TO  DISK = N'D:\server\MANDRAKE\MANDRAKE_db_200702080015.BAK' WITH  INIT ,  ...

Hi. Could anyone suggest why, whenever a third-party application that creates and uses its own SQL Server database, it creates the physical files in a location that is not the default? This doesn't seem to be an app-specific ...