sql-server-2000
How do I build a comma delimited string om SQL Server 2000?
I have a query that returns a reasonable number of records from a table.I need to include a comma delimited string as an output column.Something like this[详细]
2023-03-25 21:30 分类:问答HashBytes works on sql server 2000?
i have a client that runs a windows ap开发者_运维百科plication on a sql server 2000 database, and i am trying to run a query that works fine on sql server 2005, with the HashBytes function like this:[详细]
2023-03-25 16:53 分类:问答Can a generated table be deleted in a transaction to prevent other people from accessing it while its being updated
two relating question: I have a table that is in use in a production or live environment.Is it appropriate and possible to begin a transaction on that table to ensure no one is using that table while[详细]
2023-03-25 09:38 分类:问答Issue with parameters assignment in ADODB Command
We use an ADODB command to perform queries (call stored procedures) on our SQL Server 2000 database, using SQLOLEDB driver.[详细]
2023-03-25 06:22 分类:问答Delay a SQL Server 2000 query until processor is below 50% utilization using a query or sproc?
I have a several very expensive queries which seem t开发者_如何学运维o hog resources that seems to put the system over the top.[详细]
2023-03-25 04:10 分类:问答How to restore database from remote database?
I want to restore my local dev database from a database that sits on a different server. restore localdb from foreigndb....[详细]
2023-03-24 04:25 分类:问答SQl Server 2000 Execution: Statistics Missing
I have a sitauation in production where a procedure is taking different time in two different envionments, when I trie开发者_运维百科d to run the execution plan some stastics are missing. When I click[详细]
2023-03-23 17:17 分类:问答SQL Server 2000 query performance
We have migrated our few serevr to named instance and I have a situation where a a Stored procedure is taking more tim开发者_如何学Ce for execution.[详细]
2023-03-23 15:00 分类:问答How can I query an which Active Directory account is associated with a SQL Server user?
I have have two SQL Server\'s that I primarily use (a 2005 instance and a 2000.)My permission structure works as such--[详细]
2023-03-23 13:12 分类:问答Results form sp_spaceused in one recordset
I would like to collect all databases statistics which contain database size and unallocated size. I\'m trying to use sp_spaceused stored pr开发者_高级运维ocedure, but unfortunately I am unable to wri[详细]
2023-03-23 00:37 分类:问答