Search results for query: *

Ok, so I have a stored procedure that 'intelligently' does my DB optimisation. It uses the dm_db_index_physical_stats DMF to populate a table with details of all indexes that need a rebuild/reorg. Then from that it dynamically builds and executes the necessary ALTER INDEX statements. Thats all...

Hi I have a database which has started generating the following backup error: Msg 18273, Sev 16, State 1, Line 1 : Could not clear 'DIFFERENTIAL' bitmap in database '' because of error 5242. As a result, the differential or bulk-logged bitmap overstates the amount of change that will occur...

Hi I just installed SP2 on three of my dev boxes recently and the resulting problems manifested themselves shortly after. 1. This error started to appear in the System Log (several times a minute) - eventually taking down the server: "An I/O operation initiated by the Registry failed...

Hi Last night, for no apparent reason, our production server stopped logging job execution to the sysjobhistory table. I have checked the following: 1. Job owner account 2. Space in sysjobhistory table 3. Jobs are actually completing (tested with backups), but no log is written to...

I carried out some maintainance last weekend on one of our data warehousing SQL Servers to move all of the transaction logs (including system t.logs) onto a separate drive (it had been incorrectly setup originally). Prior to moving them I was seeing a buffer cache hit ratio in the high 90s...

Hi I'm trying to use the run_status in the sysjobhistory table to find out whether there are jobs currently running, but it seems that there is never a job step written to sysjobhistory while it is actually in progress, i.e. run_status = 4. For example if I have a job with 6 steps, and its...

I'm a SQL Server developer by day, and struggling to tackle an Access issue which I would usually handle with a stored procedure. I need to create a table on the fly (using VBA) and add the column names based on data from another table. I've created a Data Definition query and thought that I...

I've just been handed a server which is in a very bad way, with little or no information on how it got that way. It has SQL Server 7.0 installed and it also appears to have a 6.5 Server registered (???) under Enterprise Manager (although this could well just be a name). There is very little...

Hope this is easy (I just can't figure it in T-SQL) I need to transform some data, moving iteratively through the columns of one table, to create a row for every value in a new table. The old table has column headings being months of the year. So I need to transform each record for that month...

I've been developing SQL Server 2000 for some time now, and frequently use Access as a front end. When running a stored procedure using ADO I generally use the cmd.Parameters("@param1") = etc method. However, I'm working with SQL Server 7 and the moment and it doesn't like this one...