SQL 2000 patched up running under SBS2003 we shutdown and reboot automatically at 2AM into DOS and backup entire server via Ghost onto a backup and drive and restart server Question: are there any issues with rebooting SQL daily? a another consultant claims there are but I can find no mentio...more >>

Hi, In SQL Server 6.5 we have a datatype Memo, do we have the same datatype in SQL Server 2000? Thanks for help. Jason ...more >>

Hello, i've problem with a sqlserver use by Symantec/Veritas Backup Exec. Because of a wrong setting within Backup Exec, databases are marked for restore and the server won't start with a error. I succeed starting the server with the traceflag 3807. After that the setting for restore in s...more >>

Can someone give me some pointers why it might not be a great idea for SQL Server 2005 to be run on an XP workstation (not server) for commercial use? And especially given that a database could be hooked up to an Internet-facing web site thru IIS (on a different box). My general knowledge o...more >>

I am configuring SMTP mail on my SQL servers. I added all my pop3 account infiormation. When i am sending an email using xp_sendmail, xp_send amil was successfull, I am not getting messages. Then i stopped the mail services and I opened outlook all these messages are in the out look there are ...more >>

I get this error message when trying to create a database. This happens from the Management Studio, from regular queries, etc. No other posts seem to resolve this problem exactly that I can find. Thanks for any insight into this problem... USE MASTER CREATE DATABASE XYZ ON (Name = XYZ_dat...more >>

Hello! Could anyone recommend a good book on SQL Server 2005? Thanks, Igor ...more >>

I have the following query that is giving me an error that I can't quite figure out. The error I get is Server: Msg 8624, Level 16, State 3, Line 11 Internal SQL Server error. I think it is related to the sub-query or the group by. The sub-query executes successfully if I run it by itself. ...more >>

Hello, One of our Windows 2000 Servers is running SQL 2000 SP3. We need to advance the system date on the machine to perform some application testing. After testing is complete, we would fall back to the current date/time. How would this affect SQL Server operation and database recoverabili...more >>

I have just killed a transaction and it says it's going to take about 20 hours to roll the change back. Is there such a thing as a "fast kill"? I don't care about rolling this back - I just want it to stop. The process is blocking my users and I need this process killed sooner than 20 hours...more >>

Does anyone know if in SQL Server 2005 declarative RI can be used to NULL a referenced field on delete of a record from the parent table? Any help is appreciated. Don...more >>

Dear all, I know than sql server express can deploy database by local database mode without installing it to the sql server Q1.) How many concurrent user for asp.net application? Can two users connect the local mode database concurrently? Since if i deploy in server database mode, it can b...more >>

Are hardware configuration stored in system databases??? If so, do you know of the database or tables that stores it??? Thank you. Scott...more >>

I need some help with SQL Server memory usage issue. I currently am running SQL Server 2000 Standard on Window 2000 Server Standard on an HP DL380 with 4GB of RAM. The OS is reporting the correct amt of memory but SQL Server 2000 will only use 2GB, thus creating a bottleneck bigtime. After fur...more >>

Hi, I am trying to setup a 2-way txn replication from the source & destination on SQL Server 2000 SP3. is it possible to set up such replication (i.e 2-way) and how can i do that ? tks & rdgs -- Message posted via http://www.sqlmonster.com...more >>

Hello I ran an update query from access now the server is running slow. Can re index? what is the procedure/command for this? is it possible to disable all triggers when i run my update sql scripts? i ran profiler and saw a few connecting ... messages could this have something to do with this? t...more >>

Hi, our production database which is of size 30 Gigs has a transaction log file that rapidly grows by about 1 gig a day. Since there is only around 30 Gigs free space on the transaction log drive, I have implemented a job to do a backup/shrinkfile of the transaction log. My single job conta...more >>

I received the following msg resulting from a backup: (partial) "increase the maximum worker threads for the SQL Server SQLSRVR\SSDDWP_SQL2. Or decrease the maximum number of databases to backup concurrently". There is a another full backup at a different time of day on this server that succ...more >>

I use SQL Server 2000. My database is 1912.69 MB with no available free space. My logfile is 1 MB. The size of all tables and indexes add up to 200 MB. I have no diagrams, two views, fifty stored procedures, six users, ten roles, no rules, no defaults, no user defined data types, no user def...more >>

Hi, After placing SQL Server 2005 60 day eval on my 2K test box, I discovered SQL Server 2000 Ent. began throwing level 21 errors and a number of counter errors appeared in the application event log. Uninstalling 05 destroyed SQL Enterprise Manager MMC and it could not be recovered without a c...more >>

Good morning all I'm creating a table drawn from all the various books online for SQL Profiler event classes and have discovered seeming duplicates in the SQL 2005 BOL topic "SQL Server Event Class Reference" (which appeared AFTER the December update): Broker:Forwarded Message Sent - Eve...more >>

A question for Delphi experts (dare I ask it in here?) Do you know how to collect the value in a TimeStamp field? My intention is to use this value to check whether another user has updated the field whilst I have been reviewing it - and then I go to make my update. My TimeStamp field is ...more >>

Can anyone point me to someone who could advise on migrating databases. I am a system consultant (but not a database consultant or expert) and one of my customers wants to convert their database from Versant to SQL server. The Database is used to record customer information and includes the fo...more >>

Hello, We have serious issues with our production database servers once in a while we have server stops responding only option is to reboot the box to bring server online. This is going on consistently and actively working with MS support unfortunately the problem is not reproducable. We see ...more >>

I inhereted a database that has a lot of Float type columns. Typically these columns hold decimal-type data rounded to four decimal points such as: 987.1234 Is Float the appropriate data type for use with these types of columns? ...more >>

Hi all I am just wondering, will there be any issues if i use different SQL server editions in different environments for an application that requires a database? Meaning, this application that i hv writes to a database, and there are 2 environments for this application, i.e. Production an...more >>

Hi, I am getting error 8970 when I run a dbcc on my production database. Please help. Error Details: --------------- Server: Msg 8970, Level 16, State 1, Line 1 Row error: Object ID 1, index ID 0, page ID (1:92), row ID 67. Column 'uid' was created NOT NULL, but is NULL in the row. DBCC...more >>

Hello, Is it possible to Ghost SQL Server 2000 running on NT4.0 and then restore that image on another server with different hardware configuration and operating system(likely Windows 2003)??? The currentl SQL Server have DTS packages, Linked Services, Jobs, etc... If possible, what wou...more >>

Hi, I do have a large Axapta database (114GB) with following file conent: Datafiles: d:\....\data\Axapta_data01.mdf - it is 87GB - it is in PRIMARY Filegroup f:\.....\data\Axapta_data02.mdf - it is 27GB - also in PRIMARY Filegroup Logfile: e:\....\log\Axapta_log02.ldf - 20 GB - none file...more >>

Hi! My database has a table which shows the value of the weight of some equipments. weight decimal(4,2) null But when i try to insert a value started with 0 (0.90 for an example) The value which is really inserted in my table is .90 Then, when i try to list the values of my table: ...more >>

I'm getting the following errors in SQL logs when trying to even view the contents on my tape drive using EM: BackupMedium::ReportIoError: read failure on backup device '\\.\Tape0'. Operating system error 23(Data error (cyclic redundancy check).). Internal I/O request 0x0F32F428: Op: Read,...more >>

Is it possible to use the same backup tape for both Windows and SQL Server native backups? ...more >>

Hi, I've got a production server log shipping a 280GB database to a remote DR site server. It has been running without incident for months now, but last week it stopped restoring logs (the copy process was still running) with an error 3456: [Microsoft SQL-DMO (ODBC SQLState: HY000)] Err...more >>

We have been using the 'Copy SQL Server Objects' with success for some time to copy an entire database to another server. Recent changes to our database infrastructure cause DTS to fail: 1) We have a check constraint which uses a user function (which refers to the table on the check constrain...more >>

Can anyone point me to a good resource regarding SQL Server Msg 7404? I've got a scheduled job that runs a stored procedure that started showing the following after the last server reboot: Msg 7404, Sev 16: The server could not load DCOM. [SQLSTATE 42000] A reboot usually corrects this but...more >>

Hi Friends, I have a small problem hoping that you experts can resolve it. I need to make a user defined data type for a field. My field name is FINDG_NO(PK) and its datatype needs to be (Five fillers alphabatic then today's date, and then two fillers at the end alphanumeric) Here is the examp...more >>

Hi, we have some applications running on a msde 2000. We are evaluating to change it to sql express 2005. Do you know if this new version support more concurrent conections than msde?? Thanks a lot for your help. *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi How can i take time > hh:mmAM/PM and time < hh:mmAM/PM from a datetime field using a select stmt. please give me a sample query for this. -- Thanks -- Thanks...more >>

O/S = Windows 2000 Server, SP4 5.00.2195 SQL = SQL Server Standard 9.0.1399 SQL Server logs the following error in the application event log twice in 5 minutes. SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [C:\SQLData\PackLin...more >>

Hi, paws. My server crashed recently, I didn't give to much importance because I knew that having access to the partitions I could recover my DB files and attach my database to my new server, and everything was fine until .... I found that my DTS Packages and Jobs where not in my Attached DB. N...more >>

I've been reading articles and working with the samples and tutorials for a few weeks now on 2005 Notification Services and I'm just not seeing the big gain. Can someone please explain how and why this is a useful tool to implement rather than build by hand? It seems that all the work requir...more >>

using sql server 2k (guess we need to specify this now) Is it possible to get EM to allow me to navigate to a UNC path. I know how to use the following and have MSSQLSERVER running under a domain account, but the license is for the tools and point-and-click is nice. RESTORE DATABASE MyDB ...more >>

The SBS 2003 server is blue screening. The client has not done any backup in several months. I have pluged in another HDD, installed Standard 2003 and then reconnected the old HDD as a second drive. All the data from the old HDD is now visible and accessible. I can now comfortably recover all ...more >>

Hi all, Nice problems in between x-mas and a new year! I have a database created with a setup program and with a fillfactor for all indexes on 30%. So before we discovered this, we imported about 500 MB of data into the database and it grew to 10 GB - size of databasfile. After some an...more >>

hi all i have one table with the format PKEmployeeID PrimaryKey FKDeptID Salary EmployeeName FKEmployeeID here I have to retrieve the max salary by dept wise thats ok by writing Select max(salary),FKDeptID from Employee_Sarada group by FKDeptID How can i ...more >>

Viewing trace following query gives Duration - 517470 Which indexes should be created on tables and how to make this query optimized. ======================================================= SELECT top 1 package_description.name, package_description.tier, ...more >>

Hello All, I get the below mentioned error "Could not find stored procedure 'dbo.aspnet_checkschemaversion'." when I try to access a SQL Server 2005 DB from a .NET application. Anyone has any idea why this error is thrown.. Thanks in advance... Shar....more >>

About 3 years ago we were getting index corruptions on our SQL server database. MS and SAP indicated it was a H/W problem but HP after performing a lot of tests suggested the problem was a S/W problem. So to get the problem resolved MS and SAP recommended placing the two tables I was having pr...more >>

I am experiencing the following problem; I boot my Windows 2000 sp#4 machine to get a fresh machine. The hardware is Pentium 4, 3 ghz with 512 mb RAM. There are no other heavy applications running on the machine. I check sqlservr.exe's memory usage in Task manager. It is ca 20 mb, every...more >>

According to the BOL, the db_ddladmin Db role is for adding / dropping objects. I have found that objects in SQL Server 2000 means tables / views / procedures .... In this way, does it mean that database user with db_ddladmin role can read / write to all tables / views / procedures ? Wh...more >>