Hi ! Can any one help me as a newbie ASAP Pl. I need some simple code or SP to do the task,counting rows in whole DB with table name and space used, compute statistics & record it. When again run the code after few days it do comparision with the last run and shows what changes happen to co...more >>

HELP! I was working on a SSIS package trying to execute a SQL Transfer Object task when it errored out saying it didn't have permission to access the database. So I tried to manually scipt the Create Database option and it gave me the same message. Then I was kicked out completely and it won't...more >>

sp_provider_types_rowset and some other stored procedures keep being executed We recently experienced a very interesting problem. When connecting to SQL Server 2000 (SP4) using ADO, after the recordset is retrieved, we can see the following stored procedures kept being executed every we su...more >>

I have a database application that is experiencing regular (daily) sudden slow downs in performance. One minute everything is running fine, and suddenly the application is timing out processing requests that generally take less than a second. I discovered that running DBCC REINDEX on three ta...more >>

Hi, I have a database which is 10 GB big but on disk it shows 20GB. I did backup and shrinkdb but it doesn't shrink. I could shrink log but not the actual db. Any hints why I cannot do this? Also weird thing is that when I run DBCC shrinkdb I don't get any error message. Here is the exact com...more >>

Hello, I have two servers One i have just upgraded to SQL 2005 (Not SP1 yet ) and another still on SQL 2000. These servers are running on differant collations SQL 2005 - latin1_general_ci_as SQL 2000 - SQL_Latin1_General_CP1_CI_AS When these were both SQL 2000 the linked server the qu...more >>

Hi, I have a problem with the WHERE IN statement The following statement works ok. SELECT Id FROM table1 WHERE (Id IN ('{23ABFD83-0A00-40D2-8E1F-333055062862}','{B5F98C5E-F899-4EEC-BA75-AF6DFC6773FB}','{0A134F1C-3E50-4859-B36F-CC56CFF095A7}')) But this statement throws a error : Conversi...more >>

Since installing SQLExpress I have not been able to start the SQL Server (SQLEXPRESS) service. Whether the system attempts autostart or I try manual start through System Management/Services the same messages are recorded in the SYSTEM and APPLICATION logs. I get the feeling this is a s...more >>

Hi, I am using MS SQL Server 2000 SP3. In EM i have view as Default Database Diagram. In this it showing me Available free space for databse as 0.00 but, Phisically i have 11.6 GB free for the database. Currently the size of a database is 6 GB. For this DB i have Autogrow option enabl...more >>

I have a query that generates about 44 M rows. When displayed in Query Analyzer (SQL Server 2000/sp 4), it garbles the grid output. If displayed in text mode or using an adp project, the same query displays correctly. I have tested this on 4 different machines with the same results (newer laptop...more >>