I need to create a trigger in every database on my sql 2005 instance. I’m setting up some auditing ddl triggers. I create a cursor with all database names and try to execute a USE statement. This doesn’t seem to change the database – the CREATE TRIGGER statement just fires in adventureworks repeatedly. The other […]
I have a partitioned table in SQL Enterprise 2005. I need to query the PARTITION FUNCTION to find it’s partition ranges. What SQL query will give me those values?
I need to be able to schedule a job on the 10th of each month and have it run for a set number of days or until a specified date. Is there any way to customize sql server agent jobs using some sort of API or something? Thanks.
If I add 3-400 databases to a single SQL Server instance will I encounter scaling issues introduced by the large number of databases?
I’m playing with the Output keyword in SQL Serer 2005 Express. I’ve written the following query: Declare @tempTable as Table(masterLotDB datetime) Insert into dbo.tblMasterLot (RecordCreation) Values (‘2009-10-02′) OUTPUT INSERTED.RecordCreation into @tempTable I get a syntax error of Msg 102, Level 15, State 1, Line 6 Incorrect syntax near ‘OUTPUT’. I’ve tried various combinations. The query […]
My question is similar to Upgrading SQL Server 2000 to 2005 or 2008 – DTS to SSIS but I have a few restrictions that I’d like the community to consider. We have two databases that currently run on SQL Server 2000 and we are being pushed to move off of this in favor of SQL […]
Does anyone know how to insert data into a table in increments of about 1000? I have a table with thousands of records that I want to insert into an identical table on a different server.
I’m new to SQL Server reporting services, and am trying to decipher an existing report. It’s nothing too bad, but I notice it does have two report datasets defined. (They are generated via separate stored procedures) I’m trying to figure out where and how the report datasets are linked together so the Fields collection has […]
OK I’m not sure if this is valid, however I have a bug bear with SQL Server, and that is that I cannot organise objects in to a group of objects. Imagine I’m working on a new section of work in a large database and I perhaps have 15 objects that I will be regularly […]
Problem: A jar file was failed to deploy on a UAT server. Reason: Because when we are trying to rename it,it is showing “cannot rename the file it is been used by another user”. step choosen in order to solve the problem log on UAT server(xxx). we need the list of java processes along with […]