I have a nest cursor, which I have to use for this scenario. When I put the outer loop in a transaction and there is an error I get a further 'Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing' I suspect in my loop I am starting a transactio...more >>

Hello there, can some one help me with SQL 6.5, i recently deleted few records accidentally and i do not have any back up, can i get those records back proly undelete or sumthing like that. Thanks ...more >>

Hi, I'm using: SELECT 'DROP TRIGGER ' + name FROM SYSOBJECTS WHERE type = 'TR' I've used this on a number of occaisions but it doesn't seem to be dropping the triggers this time. Can anybody think of what I may be doing wrong here? Many thanks for any assistance in advance Ant...more >>

I have create a view which I use to get duplicates and near matches between two tables. Getting the near matches means a where clause with lots of OR clauses to get the various permutatiuons which are classed as a near match. So my view is like this - there are lots or variations I have only i...more >>

We have two SQL Server 2005, SP2, 64bit Standard Edition servers on Win2K3. Each have 16GB RAM and the following SQL Server Configurations: Max Server Memory: 13312 (13GB) Min Server Memory: 12800 (12.5GB) One is a dedicated SQL Server, with no other applications on the server. The second...more >>

Hi, I'd like to generate a script for only all the triggers in my database, but not the Tables. When I use the Generate script funtion in Enterprise manager, I can't enable the OK unless all tables or all views have been enabled on the General tab. Is there a way to save only all triggers t...more >>

Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of the C# CLR function when the C# CLR function is done modifying it? I tr...more >>

how to determine how many milliseconds a segment of code takes to execute in TSQL on sql server 2005? ...more >>

I'm having trouble understanding the output of SQLIOsim. The only links I have that describe it are: http://support.microsoft.com/kb/231619 http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx#ENE Is there something better out there? Right now, I noticed that o...more >>

We have neither log shipping nor database mirroring on our system, so the only way I could experiment with a standby database was to restore a backup to a new database, using the standby option. Is the database I created a hot or a warm standby? Can both kinds be used as a read-only data sou...more >>

Case: *SQL Server 2005 Ent (9.00.3054.00) *One database supporting the following countries: *Austria *Canada *Denmark *Finland *France *Germany *Norway *Spain *Sweden *Switzerland *United Kingdom *database and application is fully Unicode enabled *server collation is Da...more >>

I'm wondering if it's a good idea to put datafiles on a NAS and to run the DB Servers without local disks. Seems risky to me, but I know the topic has come up and (I hope) Microsoft has an article on the subject. Thanks, Jay ...more >>

We are using an OEM ODBC connector that, to date, only works with the 32 bit version of SQL 2005. My production server is a 64 bit version so I am still maintaing the old server with the 32 bit for this ONE connectivity requirement. The ODBC / OLEDB connector is used for a LINKED server to a...more >>

The code listed below is being used from inside Crystal Reports to build a cross tab report showing the total number of clients by level (1,2,3,E, or P) and Type (I or P). What I would like to do is add some compute statements (or something) to the end of this query that would show this total ...more >>

I have local attached storage with a raid with 3 volumes C: 72GB Raid 1+0 R: 72GB Raid 1+0 S: 72GB Raid 1+0 I also have a SAN storage setup with 1 volume designated for SQL Server with drives. G: 307GB Raid 1+0 The question is where should I place all the various database files used by S...more >>

Hi I have a simple package I am putting together. The package runs a query on an SQL database (database1) and the results are then copied over to another SLQ database (database2). I have this set up and it works. I am trying to add another element that will update a table in database1 as lo...more >>

Hi, i just want to check if i could have any problems in the future with this. The thing is that i've installed a sql 2005 enterprise 64 bits on a windows 2003 enterprise R2 64 bits, with Intel x64 cpu. But when i check on the sql instance properties it shows that the platform is NT AMD64. ...more >>

Does SQL Server use PFS to check whether a page is allocated or not if the table has a clustered index. Regards Balaji...more >>

we has all web applications and databases on one server.recently we did an excercise to move all databases to a new server and connecting it through the application server. The database is in sql server and all applications are in .Net the database server response time is very slow and all ap...more >>

I often only use one or more XML-files as database for my applications since it is very non-complicated and lets me model my datastructure in any way i like it to be. But when do I really need to consider moving up to a larger database-platform? Today I would load the entire xml-database (<20...more >>

Hi, I'm making a study about pro en contra for central and separated databases in one sql server. I googled and found some interesting opinions but most of the are about management. But what about performance, what if a database has 100-200 tables and 50 views and keeps growing. Can Sql...more >>

HI need help with INSERT/COPY i need to copy data between 2 different database. select * DB1, Table1 insert into DB2, Table1 the database structure and individual table structures are same but in different database on the same server. Highly appreciate any help. Thanks in advance. ...more >>

Can someone help me with restoring a database using sql server management studio? Every time I attempt to restore a database, I get the following message: Restore failed for Server 'localhost\SQLExpress'. Additional Information: System.Data.SqlClient.SqlError: Exclusive access could not ...more >>

Hi, On my Windows 2003 server, I just created a local account, I was planning using that account for the SQL Server 2000 log shipping. However, I don't know how to use that account to start SQL Server related services. Would some one give some advice? Thanks for help. Jason ...more >>

How do I loop through the records in a temporary table? Thanks ...more >>

Folks, we are having issues with some instances of installation of SQL 2005 SP2, which despite receiving a failure message during install, the SP appears to be installed just fine. The insatallation status notification at the conclusion of the installation show: "failure". But when you check the...more >>

Why didnt SQL server 2005 for workgroups install the SQL Server Management Studio Help Please Thanks ...more >>

Hello group, I have the following issue: select convert(varchar, GETDATE(), 105) ------------------------------ 30-10-2007 (1 row(s) affected) select convert(varchar, ini_fecha_actividad, 105) from agenda ------------------------------ 28-10-2007 30-10-2007 31-10-2007 01-11-...more >>

Folks, we are having issues with some instances of installation of SQL 2005 SP2, which despite receiving a failure message during install, the SP appears to be installed just fine. The insatallation status notification at the conclusion of the installation show: "failure". But when you check the...more >>

Hi all, I have a problem. I have a scheduled DTS package that runs every week that copies data only from staging server to production into a table. When the job is finished it states that all is successful. When I check the row count for this table there is a discrepancy with what exist...more >>

About two months ago, we had a problem with a couple SQL 2005 databases. We got everything working and all has been fine. Today, I noticed that the databases that we had a problem with have LDF file but no MDF files. I don't know much about SQL but does that make sense? Is there any way to mak...more >>

How would I find how long my full backup is taking since I started doing backup, Is there system table in SQL 2005 or SQL 2000 that will show that Thanks, ...more >>

I am looking at this syntax from Books-Online: BACKUP DATABASE AdventureWorks TO TAPE = '\\.\tape0' MIRROR TO TAPE = '\\.\tape1' MIRROR TO TAPE = '\\.\tape2' MIRROR TO TAPE = '\\.\tape3' WITH FORMAT, MEDIANAME = 'AdventureWorksSet0' 1. Am I right in thinking that this has nothing t...more >>

I am experiencing the dreaded "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed." error. It is on Sql 2000 / Windows 2003. It, of course, started to happen out of the blue. This happens when I run a maintaince plan from SqlAgent or the command line. Here is what I've n...more >>

Hello, We have aquired a new company and I need to migrate a SQL 2000 server from thier existing domain to our AD domain. Other than changing the service accounts and any SQL domain accounts is there anything else I should be aware of? old domain: nt4 new domain: 2000 native SQL ser...more >>

We're moving the QA enviornment to a new server and I want to restore the database backups (including all jobs). I know I have to restore the application DB's + model. I think I should be restoring msdb, but I'm unsure about master. What other "gotchas" are waiting? Thanks, Jay ...more >>

I have a storedproc that does several UPDATEs to a table, some of which fire and some of which don't based on various IFs through the proc. There's a maximum f three, it's not THAT complex. However there is a trigger on the table that records all UPDATEs into a separate auditing log. I woul...more >>

Hello All, I have a program that connects to a SQL 2000 Enterprise using a very plain ODBC connection. This program writes data to the DB (in a couple of tables) However it cannot view that data. You can see it with EM(enterprise manager). Any initial thoughts? I work almost excusively wi...more >>

Hello , Is it possible/recommended to do SQL server instance backups in Single user mode ? Thanks in advance, atv ...more >>

I'm trying to find duplicate records in a table. I know how to do that using a single column value, but I need to do it using the combined values of two columns, company_id and client_id. There multiple are records with the same company_id value (e.g., 123) and multiple records with the sam...more >>

Hello, By mistake I deleted database file from hard disk. Is there any way I can recover the file please? Thanks, Harish Mohanbabu -- Microsoft Dynamics Ax [MVP] http://www.harishm.com/...more >>

I'm looking at a new, freshly configured clustered server ('a' node) and examining the partitions with DISKPART. I don't understand what I'm seeing, nor do I know if it is best. First (from chkdsk) all volumes have a 4 KB AUs (blocks) and I believe that the volumes the .*df files go on should ...more >>

Hi, We are using litespeed(version 4.8) to backup databases on SQL Server 2005(SP2 database) but everytime few databases are left out although drive has enough free space and also it doesnot generate any error Script for the same is: EXEC sp_MSforeachdb 'IF ''?'' NOT IN (''tempdb'') ...more >>

Is there a defintive site I can access that will tell me all the versions of SQL2005 from release up to latest hotfixes. SP1 + hotfixes is what I'm interested in. i.e. all the possible results of select @@version We have a situation where we can;t upgrade to SP2 as we're sitting on an S...more >>

I have a user that installed SQL server SP2 and is now unable to connect through VPN. He is also unable to access our webmail system. He is able to connect to the Internet. Is there a known issue of SQL server SP2 changing connection settings?...more >>

Hi, On one of our servers(SQL 2005 SP2) I see that few processes with following entries in sys.sysprocesses waittype waittime lastwaittype 0x009D 1198545859 KSOURCE_WAKEUP 0x00A9 1198547406 BROKER_TRANSMITTER 0x007E 1198547968 ONDEMAND...more >>

Is there a sure way of finding out all the SQL Server instances in a given domain? I have read few post but have not seen anything that will give accurate result. I am in the need of it, can anyone please help me. Any help in this reagrd will be greatly be appreciated. Thanks ...more >>

Despite all the best practices for NOT using cursors, I have a from-the-box application that uses a large amount of cursors. Can anyone send me to a place where I can read optimizing rules on the database for using those cursors. Thanks in advance, JohnPaw...more >>

Dear All, I am trying to calculate the size of a cluster index using the "Estimating the Size of a Clustered Index" section of Books online. Can some body tell me what the below formula means Calculate the number of pages in the index: Num_Index_Pages = ∑Level (Index_Rows_Per_Page)Le...more >>

Hi all! What is the best way to save a time value (not the date) in a column of a SQL Server 2005 database? Thanks in adavance. -- Marco Minerva, marco.minerva@gmail.com http://blogs.ugidotnet.org/marcom ...more >>