I've made a demo showing the use of an Event Notification. It has worked a 100 times before but all of a sudden it doesn't !!?? Here's the code and everything else is in place. I've just installed the server and it's a Developåer Edition and I'm using the good old Northwind Database. It has th...more >>

how to change database collation? ...more >>

While attempting to use SQL Server Manager 2005 to restore Test1 to Test1Copy1 at least 9 times out of 10 I get the following error: // Restore Test1 to Test1Copy1 System.Data.SqlClient.SqlError: The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test1.mdf' cannot be overwrit...more >>

Hello, How is load balancing working in SQL Server 2000. We want to have two different servers as a back end for our web based eCommerce application. Is this possible? While there be any modification requirement in the application? ...more >>

We have a SQL service that consistently seems to take about 10-12 minutes to start up. After it finally started, everything is hunky dory. I was able to review the SQL Server logs in the Enterprise Manager. The SQL startup hangs on "attempting to initialize distributed transaction coordinator." ...more >>

With SQL 2005 Standard: I have records in a table that show how long it takes to complete a task... ID_KEY DATETIME (nearest minute) DURATION When a task is started, a record is added with a "null" duration, and when the task is finished, the duration is updated to represent the...more >>

Hi Why the option Use Windows NT fibers isn`t work in Windows 2003. What can I do for use this option and use more priority with SQL server? Using SQL 2000 in Windows 2000 is better. Why? Please help me. Ideas Mr I have SQL Server 2000 in Windows 2003 using Threads with .NET ...more >>

When moving from a SBS2000 server with SQL2000SP4 and using detach and then attach on a new SBS2003server (Prem. edt) with SQL2000SP4 then many fields behave as date field and there isnt any data in them, any sugestions? /Per W. ...more >>

hi all, i am having a hard time getting the conversation handle id to match ... scripts that create the relevant objects ... create message type QueryMessage validation = none create contract QueryContract (QueryMessage sent by initiator) create queue QueueSender create queue QueueReceiver ...more >>

I just created a full text index on a table and everything appears fine but after populating it I still have an item count of zero. Any ideas? tia, jj ...more >>

Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, ...more >>

Hi All How do I move a database from one server to another? Is it a problem that the original server is SQL 2000 and the new is 2005? ...more >>

Installed adventure works..and when creating a database diagram giving a message says that it does not have valid owner. The adventure works database is in SQL 2005 compatibility mode. ...more >>

Are there strong reasons not to have SQL Server 2005 and Windows Media Services running on the same server? It seems SQL is more processor intensive and WMS is more bandwidth intensive and they might share the same server pretty well. Sure, if the budget was there, each would get it's own box b...more >>

I am working with the RTM Standard Edition of SQL Server 2005 and Deadlock trace output is not getting written to the error log. I use the -T startup parameter and specify -T1204; -T 3605. I set the startup parameters using the SQL Server 2005 Configuration Manager. I then restart the SQL S...more >>

sql2k Im comparing a username/ password to an App role/ password and Im just not seeing the logic here. An App either needs to supply a username/ password or a "sp_setapprole @rolename = 'TestRole' ,@password ='test'". Either way they are granted access to the DB. Either way they can only e...more >>

I am attempting to exports the results of a stored Procedure into a CSV. The table is a temp tabel named #FinalPrivate. I need to allow a user to download the file from a .NET Web Application. Is there someone that can point me in a direction?...more >>

How does the number of objects (specifically tables) affect overall performance of SQL Server? Does SQL Server slow down as more objects are added - even if the overall data size remains relatively the same? How significant is this slowdown? Is it noticible after thousands of objects, mi...more >>

I currently have a 2-node, active/passive cluster running SQL Server 2000 w/SP4, running just the default instance. I am looking to add a 2nd instance, but I have a couple of questions on how to start: 1) I understand that you have to re-run the install and create the 2nd instance. I've alre...more >>

I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory Manager/Total Server Memory). I would like to allocate nearly all of the ava...more >>

I am trying to send SMTP email with attachment using cdosysmail and getting error on this line: EXEC @hr = sp_OAMethod @MailID, 'AddAttachment', NULL, @FileSource Error message: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should...more >>

We are building up a clustered server configuration with two nodes. Each node will be an HP ML580 or DL 580 with 4 processors per server. Do we need to buy two Enterprise licenses (one for each 4-processor server) or 8 licenses (one for each processor on each server)? I am getting conflicti...more >>

Greetings to all! I was curious if there was a way to determine what fields are in use by stored procedures and/or views in a database. If there's a way through SQL or through VB .NET, I would be most appreciative to learn about it. Thanks, Kyjan ...more >>

HI, I am trying to rename a table, it gives me this error, Object 'Test' cannot be renamed because the object participates in enforced dependencies. How do I rename a table then create a new table with the original name. thanks, ...more >>

I have just installed a new SQL 2005 server on a Windows 2003 server with regional settings set to English (United Kingdom). Despite the setting on the underlying server the SQL 2005 server displays it's language as being English (United States) in the server properties screen (greyed out). ...more >>

Hello everyone, We're going to migrate our SQL 2000 server from one domain to another. I need to get a better idea of how our current databases are structured and utilized. What I want is a report showing each database's: name data size log size users if backed up or not Before I ...more >>

Hi All, is it better to use Begin...Commit in all SP? does this help preventing deadlocks? thanks in advance. jouj ...more >>

Hi, I am trying to script the creation of the Stored Procedures. But can not get the script to have the bits for if exists then drop bit. Thanks...more >>

I have a health check result table for students in a primary school. The table is like below. I use pivot to count the students count for every resultID: Select GradeID, Gender ,[1] AS r1,[2] as r2 ,[3] as r3 FROM (SELECT CheckID, GradeID, Gender, ResultID FROM [Result]) p PI...more >>

Hi, I am facing one wierd problem. I have one table having column as Ntext, from front end we are inserting 50000 characters.Replication is enabled , when we are inserting 50K characters we are getting error "Length of text, ntext, or image data (100000) to be replicated exceeds configu...more >>

Running the script below the error number is not generated and the transaction is rolled back ... Should be like this, or it should nicely give the error number and let me decide what to do? This is very usefull when using EXECUTE() or sp_executesql(). Here is hwo you can reproduce the prob...more >>

I have installed a backup server with the German version of Windows2000 and SQL2000. By default, all program files are stored in the folder “c:\Programme\Microsoft SQL Server\…\Data\”. If a rebuild the master database with the rebuildm utility, the files are copied to the “Progr...more >>

Hi everyone, I have to update a column with about 1.34M rows. The column is a a primary key and hence has a clustered index associated with it. I have to run updates o nthis column. Would it be quicker to do the following: 1. Delete the index 2. Run the updates 3. Recreate the index ...more >>

we have application and customized it by using VBA In VBA Code i run some queries witch summrize some information we plan set the query in stored procedure then we execute it from VBA insted of run query from VBA so how this will effect in performance Thank you for your help ...more >>

Hi guys, I have an asp page that needs to show data based on date criteria. Basically the user selects a date and the asp page should display all records within that day. The problem is that this field contains date and time. My current query is as follows: RS.Open "Select * from DB1.dbo.l...more >>

Hi, I have a situation in which a record in inserted into a table say table1 when any record is inserted in any table in the whole application. Is it better to use trigger or to write the insert query in the SP for every table itself. ...more >>

can I use enterprise manager 2k5 for adminestering sql 2k without any problems? thnx ...more >>

I am a defacto DBA and we have a 2 node clustered (active/passive) SQL Server. When SQL Server was installed the error log file location used was the default location. That path lists the local share and not the shared cluster path. Now if the server has to fail over to the other node, SQL ...more >>