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
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,
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.