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
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:
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
We use an ADODB command to perform queries (call stored procedures) on our SQL Server 2000 database, using SQLOLEDB driver.
I have a several very expensive queries which seem t开发者_如何学运维o hog resources that seems to put the system over the top.
I want to restore my local dev database from a database that sits on a different server. restore localdb from foreigndb....
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
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.
I have have two SQL Server\'s that I primarily use (a 2005 instance and a 2000.)My permission structure works as such--
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
加载中,请稍侯......