I have a fairly large database that takes up around 7GB of space on my hard drive and on top of that, one of the tables in the datatbase with about 25 plus columns has 4 million rows. The problem I am getting is whenever I restart the SQL Server service or at bootup, my database shows an (In ...more >>

Primary Key is usually designated as PK but what is PF as can be seen in the Books-By-Author table in this diagram []1? <%= Clinton Gallagher [1] http://www.databaseanswers.org/data_models/libraries_and_books/index.htm ...more >>

Hello I have have troble with a database on our server. I created a blank database and imported the data from the database which was giving us problems. I have some how linked the two databases to the one database file so when I change one database they both change. How can I unlink ...more >>

hello hi I have traces running on almost all my production servers which monitor activities like drop, truncate and alter. I have this implemented via server sides traces (SST). What these create are ..trc files as output. Now manually I can open these in profiler and view them, but no...more >>

I have a vendor trying to tell me that the order of the switches in the boot.ini will make a difference for allocating memory to SQL Server. We are running Windows 2003 Enterprise Server and SQL 2000 Enterprise Server with 7GB of RAM. We have entered in the /pae /3GB switches and they change...more >>

Hello, everyone Can somebody clarify what type of ther error it is ? Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 2/23/2006 Time: 3:01:03 PM User: N/A Computer: XXX Description: Error: 70000, Severity: 10, State: 1 Input buffer for proc...more >>

Hi, I seems to having this issue that a database is changing itself on the access rights to a 'restrict access for single user mode'. Basically I did not do anything to change that mode, but may I know if there is any way that I can prevent it changing to the single user mode? Currently I'm ...more >>

I have a backup file with many daily backups appended. I'd like to view the contents and delete a few. The file won't fit on the local machine, so it's on a mapped drive. When I go into EM's management, backups node, adding this device is not allowed via this mapping--only local drives. Ho...more >>

Hello my configration of sql mail is ok. how can i send a mail using sql mail in a stored procedure?, one example, please. Thanks ...more >>

My SQL server has 1G Ram, and I noticed that it was using about 700MB of it constant. Next day I looked and usage was gone up to 798 constant. Is it possible that SQL server is not releasing the memory it is using, thus causing slow downs, and lock finally. My guess is that SQL server doesn't...more >>

hi, i need somebody`s help. I need to to make a "select" to sometables stored in some diferent databases! please, i need help! nice day!...more >>

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition Server. We setup a database maintenance (Database Integrity and Index, Reorganize data and indexes, etc. ) to run every week. However, the report shows that the maintenance job did not run because the database needs ...more >>

Hi, I have a sp created. everytime I run from query analyzer I got this error. A RETURN statement with a return value cannot be used in this context. Any ideas, Thanks ...more >>

I can't figure out how to take display my results like so... NJ --Trenton, John Doe --Voorhees, Jane Smith Pennsylvania --Philadelphia, Ken James --Pittsburgh, Alfred Herms NY --Brooklyn, Llyod Banks --Syracuse, Howard Douglas within a SQL statement.. ...more >>

I have a staging table that does not any indexes. I am just using the table to store data until I DTS (transformation) it to a different server. I have noticed that after a while or on large datasets the table will become non-responsive. I can select top 10 * from the table just fine. Howe...more >>

I have loaded Windows 2003 Server with Service Pack1 on a new server. What are some of the items that should be checked before loading SQL Server 2005 Enterprise Manager on this server? Thanks,...more >>

This has probably been answered before, but... I have a local SQL Server 2005 instance running, and I would like to have another user on my network connect to this instance. However, when he tries to connect, he always receives the same error message: "An error has occured while establishin...more >>

How may I get a trial version of SQL 2000 on Microsoft's website? When I search, I get a link for it (www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx) but when I go to that link I get an error message. Is it simply no longer available through them? Is there another s...more >>

Hi all - We're running SQL 2000 Enterprise SP3 on Win2003 w/ 4GB of memory. Is using AWE necessary on 2003 server? All the info I can find pertains to Win2000 Server. Thanks -...more >>

Hi all - We are running an ERP application w/ SQL 2000 SP3. By enabling 'awe', I've allocated 3GB of memory for SQL to use (verified by exec sp_configure); however, with a reasonable load on the system, SQL is only using 110MB. This is a quad processor box, and the CPU's have an unusual...more >>

What we want to do is take all of our data on site, at the end of every day, upload all of the tables which we have updated minus one table from which we will only send all new records from the day to a server we do not have access to. We will most likely use a delimited text file, and FTP it to...more >>

This problem first appeared last week. I'm using SQL Server 2000, and nobody's made any modifications/updates/service pack installs recently to either the database or the physical server. Here's the version information: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ...more >>

I am getting the following error when trying to connect to SQL Server 2005 Express through Microsoft SQL Server Management Studio Express CTP. "Cannot connect to SERVER\SQLEXPRESS Additional Information: Instance Failure. (System.Data)" One thing I noticed, the "SQL Server (SQLEXPR...more >>

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server. We setup a SQL backup to run under SQL. We got the messages in the report. It said "backup cannot be performed on database 'msdb'. This subtask is ignored." and "Backup cannot be performed on database 'pubs'. This ...more >>

I need to develop a backup plan for my SQL Server using the Databse Maintenace plan. What is the recommended configuration to backup the server. I will be backing it up to the file system first and tehn eventual backup it up to tape via a nother server. ...more >>

Is there any site that shows me steps how to add linked server in Enterprise manager?...more >>

I'm looking for help moving SQL Server to a new machine. The current SQL machine runs Windows Server 2003 ... we recently upgraded SQL on this machine from SQL 2000 to SQL 2005 (dev). The new machine runs Windows Server 2003 (x64) and has a fesh install of SQL 2005 (dev, x64). I haven't see...more >>

We have one machine on which we upgraded from SQL 2000 to SQL 2005 a couple months ago. On this machine, \Data\ is located at C:\Program Files\Microsoft SQL Server\MSSQL\Data\. Recently we've set up a new machine with a fresh install of SQL 2005 (x64), and on that machine, \Data\ is located at...more >>

Hi, first thanks to everyone for all the help in the past. I've got a SQL std database running on a dual xeon with 2GB of memory. I've got a process on another machine that has 4 threads calling a stored proc that does about 5 INSERTS/UPDATES and 3 or 4 SELECTs per second. My disk queue len...more >>

I have downloaded SQL Express 2005 and it is working fine. I wanted to explorer new features of SQL Server 2005 SSIS (Integration Services) on my home PC. I have SQL Express 2005 installed and obviously it does not have IS(integration services). My option is to buy SQL 2005 developer edition ...more >>

Hi, Does anybody know how to put database into standby mode (not by restoring database...). I.E. Setting status flag to some value in sysdatabases? Thanks...more >>

Could someone give me a good explanation of the status column located in the sysindexes system table. Andrew MCSA,MCDBA...more >>

I have a stored procedure that I am executing through the sql server job scheduler, it executes properly but after each line in the log file there is a sqlstate message. procedure name p_document_purge [SQLSTATE 01000] Archiving records [SQLSTATE 01000] 51 rows archived [SQLSTATE 01000] Purg...more >>

We are trying to automate an import data from a table in a filemaker pro database to a table in a SQL Server 2005 Database. Is this possible using SQL Server 2005? If so, what are the steps I need to take? ...more >>

i understand the difference i think between deny and revoke and how they work but i'm confused. if i do a revoke select on Table1 to USER1 then run the query below (permission query), USER1 does not show up with access if i grant permission then use the deny select on Table1 to USER1 then ...more >>

Hi everyone, Hope you can help me here please. We are going to stress test a VB.NET coded application (a web service to be exact) that pulls from a SQL server 2000 database. I am looking for some nice free measureware that we can install easily on the Server that will show some nice graphs ...more >>

Hi, I have question regarding running totals, here is my SQL code so far: SELECT Month(DateUsed) as Months, COUNT(DateUsed) as NumUsed FROM TempTable GROUP BY DateUsed What I also want in there is another column giving me the running total of 'Count(DateUsed)'. I have...more >>

Hello I don't know what i did but my sql server icon has disappeared from the system tray and the Administrative Tool folder is blank. Can anyone help to get it restored? ...more >>

When running a step within my DTS package I'm receiving the following error - "Provider generated code execution exception: "EXCEPTION_ACCESS_VIOLATION". I think it may be something to do with my global variable, but I'm not sure as I'm pretty certain I've set it all up correctly. Below are...more >>

Are SQL Server 2000 and 2005 compatible with .NET Framework? In case they are, can I have a link or maybe a whitepaper which explains the compatiblity between both of them. Thanks much...more >>

Hi, is there a way to attach a DB's file locate on a remote path ? why SQL Server allows attach only from local drives ? Thanks Adriano ...more >>

I'm planing to install SQL2000 IA64 on Itanium server with win2003-IA64. Not sure if I need to add "Lock pages in memory" right to SQL service account or not. I know it must be used on x86 and is also recommended on x64 systems because they use AWE but on IA64 systems AWE is not used so I would...more >>