Tag: sql-server-2005

Create a DDL trigger in every database on a 2005 instance

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 […]

How to get partition ranges in SQL 2005

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?

How to customize sql server agent jobs

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.

Does SQL Server 2005 scale to a large number of databases?

If I add 3-400 databases to a single SQL Server instance will I encounter scaling issues introduced by the large number of databases?

SQL Server 2005 Express edition Output keyword syntax

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 […]

Upgrading DTS packages to SSIS Packages

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 […]

insert data in increments

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.

sql server 2005 reporting services— how to use multiple datasets in report

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 […]

Sql Server Object Organisation

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 […]

How to get the list of java processes along with their PID(process id) that are running on UAT server under a specfic account?

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 […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.