Search results for query: *

All, In the rescent times someone in the company is dropping the linked servers. Is there a way to capture who is dropping the linked servers on a particular server. Is there any DDL triggers available. Please let me know Thanks

Hi, Is there a way to figure out what is being allocated in the data files. for eg I have 10 files on the primary filegroup and wanted to shrink it to 1 in order for me to make different filegroups. The database is huge. Is there any way to determine what is being allocated in a file. Thanks Sen

Hi all, I have archived 100 Million records and wanted to shrink the data file where it contains 15 Gb in order to free up some space on the drive. When I execute DBCC SHRINKFILE (NAME, 20000) I get the below error File ID 5 of database ID 9 cannot be shrunk as it is either being shrunk by...

Hi, I am having issues with Datetime Variables in the execution plan. I wanted to select the data for a given date from a table. When I use values in the where clause the execution plan shows as Index Seek (0% Cost). The same query if I assign the value to a variable and use it in the where...

Hi all, I have a table trigger which invokes a DLL. I tested the DLL with sql server 2000 on x64 bit and it ran without any issues. But when i run the same on SQL Server 2005 on x64 Bit i get the following error [Microsoft][SQL Native Client][SQL Server]Could not load the DLL C:\XP\XP.dll, or...

Hi, I have created a SQL Server Partition on a 300 Million record table last year and now that it is fragmented. I would like to defrag it using sql Server 2005 Alter index statement. The fifth partition is fragmented, so I ran the following statement to defrag during the maintenance window...

I am getting the following error whenever I tried to create a diagram. Anyone encountered this issue. If so please help. Invalid column name 'uvalue'. Invalid column name 'uvalue'. Could not find stored procedure 'dbo.sp_upgraddiagrams'. Object is invalid. Extended properties are not...

Hi all, I am generating the trace file from production. I need to replay the trace on my testing box to generate the data in the trace file. For eg if i insert 10 records in production when the trace is running. I need to replay the trace file in the test environment and the data should be...

Hi all, I am installing SQL Server 2005 on Micrsoft Windows 2003 (Dual Core AMD opteron). After Installation whenever I start SQL Management Studio it take one minute to pop up. To check what is going on I opened the command prompt and executed NETSTAT. I see the server is trying to connect to...

All, We have installed SQL Server 2005 on a X64 with 64 Gb RAM. This server is very slow in response and when we checked the TaskManager it is using only 1 Gb of RAM. Can someone let me know if they have seen this problem. If so is there any way to rectify this. Am i missing some parameter...

Hi all, I am trying to migrate a SQL Server 2000 DTS Package to Sql Server 2005 SSIS. I have a DTS which contains active X script which creates a xls file with columns. '********************************************************************** ' Visual Basic ActiveX Script...

Hi all, I am trying to migrate a SQL Server 2000 DTS Package to Sql Server 2005 SSIS. I have a DTS which contains active X script which creates a xls file with columns. '********************************************************************** ' Visual Basic ActiveX Script...

Hi all, I am in a die hard situation. Please help I have a database where 2 tables are partitioned and the total number of data and log files in the db is 18. There is a need to detach and attach the database once in every month which has to be automated But the problem is detach works great...

Hi all, I am having some issues with BCP in SQL SERVER 2005. Can some one help me please. CREATE TABLE ##t1 (id int identity(1,1) , records VARCHAR(8000), get_date datetime default getdate()) CREATE TABLE ##t2(records VARCHAR(8000)) insert into ##t2 select records from ##t1 order by id...

All, In 2005 whenever I use the SQL Server Disk Usage report. I get some weird numbers. Can some one tell me is this a normal behavior or anything to be concerned. Total Space Usage : 261,900 MB Datafile Space usage : 394,950 MB Transaction log space usage : 11,900 MB Data file Space usage...

All, Is anyone implemented Partitioning in Production SQL Server 2005 Instance. If so can you let me know if you guys found any issues with it. Please let me know. Thanks Sendba

Hi, I have created a filegroup named CardPin and I created 2 files under this filegroup Cardpin1.ndf and Cardpin2.ndf. Can someone please let me know how to find which objects reside on which files under the same filegroup. Thanks in advance Sen

All, Can someone let me know how to resolve the following issue. I am trying to disable a Replication on a Publisher. When i tried to disable it, I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Microsoft SQL Server Management Studio...

Hi all, I have configured replication in sql server 2005. Unfortunately my distributor server crashed due to hard ware failure. Now I am trying to remove replication from the publisher. It is not allowing me to delete. What are the steps i need to follow for removing Replication on SQL Server...

All, The following errors are generated when I replayed the trace on Test 2005 Instance. Query ran longer than maximum allowed time and was canceled. Query ran longer than maximum allowed time and was canceled. Failed to replay event Query ran longer than maximum allowed time and was...