Search results for query: *

Hi hmckillop, Can you please let me know which event to use for capturing Drop linked servers?? Thanks

Mich, I tried to create the DDL trigger. I used the below syntax but got an error. CREATE TRIGGER ddl_trig_database ON ALL SERVER FOR DROP_LINKED_SERVER AS select 'Delete' GO The error is Msg 1084, Level 15, State 1, Procedure ddl_trig_database, Line 7 'DROP_LINKED_SERVER' is...

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

I figured out a solution to this issue but simply growing the file by 50 MB and reissuing the DBCC shrink command and it started to shrink. Thanks

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...

George, I have tried all the things including Droppping and recreating the indices and updating the statistics but nothing helps. Its a 20 Million record table. If have that kind of table please check it yourself you will know. Please help Thanks

Hi GMmastros, I am getting Datetime for the query which you have sent.

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...

Yes

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...

Its a brand new server with only SQL Server loaded.

I thought SQL Server 2005 will use the memory automatically but why we need to set the min and max memory. Whenever I try to open Mangement Studio it hangs for one minute because it is trying to connect to a server which is not available. Please let me know how to solve this issue. Sen

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...

Thanks for suggestion. You can be a great guy in managing forum's. There is a way to tell us.