Can I monitor response times from SQL ? I want to catch what happens between the user hitting a send key, and the final response back to them. I suspect I have to do something outside SQL for this. (We use BEGIN TRANSACTION and COMMIT TRANSACTION but that does not give or identify total tr...more >>

Has anyone got a Profiler definition on how to get stats (CPU, duration and reads is good) for table scans. The standard Profiler event seems to be only an indicator that a scan happens, which is not much use really....more >>

I have three questions?? 1. I have a Sql server instance running without any name, it just has a default name (local), when i try to go configure replication its says that replication does not support (local) name. This server is in production right now. And it will be hard to shut it down. ...more >>

Hi, After I do a full restore to a target reporting box, I continue refreshing the target with shipped transaction logs. Is there a limit to the amount of transaction logs that can be shipped before doing another full restore. For example and being extreme, could I continue shipping logs for ...more >>

Hi, I am having some difficulty extracting the xml that is required using FOR XML EXPLICIT and I am wondering if you can help me please? The target xml format is this; <?xml version="1.0"?> <U sid="NE123ZQ456" dir="0"> <P num="1234567" f="502" x="1" d="22" t="1"> <c i="1238" t="1"> ...more >>

Hi All, I am running SQL server 2000 with sp3a on Windows Server 2003,I am running 6 data bases on this server & the authentication type is mixed. I would like to know what are the implications if I change the sa password. Also would like to know what all the precautions to be taken to do s...more >>

Hey guys, I am able to record id threads and sql threads using Performance Log. It is currently being saved to a text file, and comma delimited. The data that is being saved is CPU Processor time of that thread. I have found the article at http://support.microsoft.com/?id=117559 I'm also r...more >>

See it being used in a lot of examples and not too sure why and whats its origin ? Can someone enlighten ? ...more >>

Using MSDE....(8.00.760 SP3) I have the following query...I taking this from ms-access, but lets just stick to using the EM here... SELECT ProductName, SerialNumber, UnitPrice, (SELECT SUM(UnitsAdd) FROM inventory ...more >>

Dear all, Since my old server's harddisk drive nearly used up all the free space, I need to copy it from new server. Can I simply copy all the dat and log files to new server without detach it provided that there're no user using it and after that I attach them back to new sql server? ...more >>

Hi all, I have a XML file that looks like below. The same fieldname are used for different purposes. ---------------------- - <Payer> <BusinessPartnerNumber>00101</BusinessPartnerNumber> <BusinessPartnerName>Name1</BusinessPartnerName> </Payer> - <BillToParty> <BusinessPartnerNumb...more >>

[Microsoft]]ddbc sql server driver][sql driver] violation of primary key constraint 'aaaaakeycode.pk'. cannot insert duplicate key in object 'keycode'(#2627)[Microsoft]]ddbc sql server driver][sql driver] The statement terminated.(#3621) Please help me, I am a newby and I was looking at th...more >>

Hi, When I setup SQL Server Enterprise Edition, the setup asks the license mode and the number of clients or CPUs. But it doesn't appear in Personal Edition setup. What does the number of licenses do? Am I really limited to the number of clients? Why Personal Edition does not ask? Thanks, Leil...more >>

Hi, After installing SQL Server on another machine and attached my database MDF file, I noticed that my stored procedures are gone. I've got all my tables in tact, but my sprocs are missing. Does anyone know if they are lost or can I somehow extract them from the MDF file. Thanks, ...more >>

If I set this at teh server level - in EM properties of a server, what will happen? Will all connections have it, or is there a default on the connection string which overrides? If it is used, what are the implications - any downside? TIA...more >>

The only time I've come across this is when using a linked server in a trigger - QA requsted that it be added. Can anyone explain a little more about it please? TIA....more >>

I hope you guys can help. I am looking to create a trigger that watches for updates to the sch_status column and fires when the update changes the value to 4. The code that will be executed is below with addition of some code to e-mail the results. It is the actual code to create the update t...more >>

We have a rule for developing database-driven applications that all interaction with the database must be done through stored procedures i.e. all selects, inserts, updates etc. I am looking for simple ways to enforce & support this design principle - and one would be if I could put the SQL ...more >>

I found this useful: http://www.perfectxml.com/articles/xml/importxmlsql.asp#4 But I didn't get the example (DTS ActiveX Script & MSXML 4.0 DOM) to work.Got the error message: 'Can't create object: MSXML2.DOMDocument.4.0' /Kent J, ...more >>

Databases were migrated via detach/attach from SQL Server 2000/Windows 2000 to SQL Server 2000/Windows 2000 and now scheduled backups and even manual backups say they complete successfully but the backup only runs for like 10 seconds and a backup file is not created. The file pops up in the di...more >>

Hey guys, I used this guy's stored procedure to decipher my profiler output table hopi ng to find long running or cpu intensive queries. I found it at http://vyaskn.tripod.com/analyzing_profiler_output.htm And below is what I saw after running the CPUintensive sp against my profile r outp...more >>

Hi, My application using foxpro sometimes seems like hang and when connect to sql server. I directly go to the sql server and use sp_lock to check whether there is any thread is waiting and find out there is indeed one thread is waiting and i use sp_who and can see one process got blocking....more >>

Hello: We have a server with a small database (1GB) serving a web application with users all over the globe. It also has another database (100GB) that has historical data and is seldom queried. Users query the large db data seldom and can accept slow response times since they typically downl...more >>

Hello gentlemen (ladies if there are), We are trying to run a web server, we are in a test phase at the momen and we face one particular problem that causes a lot fo problems. We ar running Server 2003 and SQL 2000 sp3a installed on it. Everything work fine but only for 24 hours or around. Afte...more >>

Hi, Are there any difference(in performance) between these two type of join: SELECT Customers.CustomerID,orders.orderid FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID & select c.customerid,o.orderid from customers c,orders o where c.customerid=o.customerid ...more >>

We have a database that is getting fairly heavy use. Our client complained that on a certain task it was performing slower than usual. The last time this happened I manually ran our optimazations job and it fixed the problem. After that I set up our optimazations job to run every night. Thi...more >>

Hi all, I'm new to XML. How can I import a XML-file to a SQL-table? /Kent J. ...more >>

In Oracle and other databases there is a way to dump all the values that have been set using the SET command. For example, SET ROWCOUNT. Is there a way to do this in SQL Server? The reason I ask is because somewhere in a stream of some 1000 sql files someone using some SET parameters that...more >>

Hi, Is it possible to update the underlying table using materialized view. I understand that a materialized view will show the updated table information in event anything changes. But, i want to know if i can use the materialized view to update the table. TIA ...more >>

Hello, If I have a job scheduled to run at 01:00 on Sunday, what is going to happen when the time changes ahead one hour? It's a SQL 2000 server running on Windows 2000 Advanced Server. I don't recall there being any issues last year (or in the spring when the time went ahead by a year)....more >>

Hi, During an upgrade from sql server 6.5 to sql server 2000 I receive the follwoing error and the upgrade process remains stuck until terminated manually: ODBC error 605 (HY000) Attempt to fetch logical page 1430280 in database 'nice_cls' belongs to object 'NICE_CLS_CALLS_0008', not to ob...more >>

Hi, I am configuring a SQL Server 2000 64 bit machine and would like to know if there are any service packs or hot fixes out there. From what I understand 64 bit comes with SP1, SP2 and SP3 all rolled. Just wanting to make sure. I also am having an issue with the 64 bit recognizing all of m...more >>

I have a table with no dependencies. I cannot drop the table. I tried from EM to delete it. I tried from Query Analyzer. I cannot even delete an index that it has. It's not a big table and it only has about 6,000 rows. Any ideas where to look? Thanks....more >>

hi, i am doing development using a number of databases on my local machine. i have one database, entitled sec, which largely consists of one table. this table has 35 million rows. the database itself is ~ 7GB for the log file and ~5GB for the data file. i had about 15GB free on my har...more >>

SQL 2000 SP3a running on W2K Server SP4. Access 97 front end. Back end was ported from Access. I get the following two errors several times a day. Searched in the KB and the only article (827714) that comes close doesn't seem to address my problem. Unless the hotfix it mentions is the answer... ...more >>

Hi, select equityID, tickerRealtick, high52, low52 from equities where isActive = 1 select max(high) from prices group by equityID The above are my two base queries. I have a table, equities, that has a list of stocks. I have another table, prices, that has the high for the day. I ...more >>

Hi, I have a question about the report of SET STATISTICS TIME ON. I run this query: SET STATISTICS TIME ON GO SELECT Customers.CustomerID, Orders.OrderDate FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID The report is like this: SQL Server parse and compi...more >>

Do the following: declare @test1 real, @test2 real, @test3 real set @test1 = 1000000000 set @test2 = 11 SET @test3 = @test1 - @test2 select @test3 select cast(@test3 as int) /* Please don't tell me to use "int" instead of "real". The cast at last line is only to see a more readable...more >>

Is there away to place at the beginning of a SQL Server job step the maximum of amount you would like this step to execute. If the job steps executes greater than this amount kill the step and go to the next step. Please help me with this issue. Thanks, ...more >>

I am moving a sql database from a windows 2000 server to a new windows 2003 server. I read where there is 3 ways to do this: • Backup and Restore • Sp_detach_db and Sp_attach_db stored procedures • Import and Export Data (to copy objects and data between SQL Server databases) My q...more >>

Hi there, I have an SQL7 server co-located in a data centre. My colleague created an SQL database using MSDE on his XP Pro machine. He is using an Access Project to manage the database. When he goes to export the database to the SQL7 server using Access it refuses to work. I have Enterprise Mana...more >>

The SQL online book claimed you can't drop a table with a view having schemabinding. However I was able to drop a table from SQL 2000 when there is a view with schemabinding. Is the document incorrrect? I can even change the table structure but the structure change does not refresh in the vie...more >>

I have two tables Product table and Prod_det table I have a need to update Product table field with the value from Prod_det table field value. But Prod_det table has more than one column that matches the key with Product table. Ex. Product schema = ProdNo., Type_Work, ... Prod_det schema...more >>

Greetings, I'm puzzled about a huge performance difference we're seeing during a database upgrade. Details: We have two tables, A and B, with the following structures: A: PKCol uniqueidentifier (pk) UnqCol1 uniqueidentifier DateCol1 datetime NumCol1 numeric(20,0) VCCol1 var...more >>

Hi all, i need to upgrade from my Local installation to a Clustered installation of SQL Server 200 on Windows Server 2003 Enterprise Edition, after running the installation program and go to the Screen "Existing installation" the option "Upgrade existing installation to a Clustered install...more >>

Hello. When you turn Logging on, for a DTS package, it appears to save the history forever? If that's true, is there an option to clear DTS package logs, after like 30 days? or would you need to write something to do this purge manually? THanks, Bruce...more >>

Last night, I posted the message "HELP!: A Disasterous Delete" (Friday, October 29, 2004 1:20 AM). This morning, as I pressed ahead with my work with my smaller data extract, I have had a recurrence of the problem of the mysterious deletion of ALL RECORDS, but now with the smaller data extract....more >>

I have a need to store PDF, TIF and other files at TEXT fields on my SQL2000 Server and them retreive them and restore them to the disk (VB6). I created a table CIP_DOCUMENT_ID int no 4 10 0 no (n/a) (n/a) NULL NAME varchar no 255 no no no SQL_Latin1_General_CP1_CI_AS BODY...more >>

Is there away to place at the beginning of a SQL Server job step the maximum of amount you would like this step to execute. If the job steps executes greater than this amount kill the step and go to the next step. Please help me with this issue. Thanks, Example: Step1 DBCC DB...more >>

Is there away to execute the DBCC SHOWCONTIG without this program creating a table lock? Thank You, ...more >>