Tag: sql-server-2005

Transacation Log Backup

How can i check with SQL query whether transction log backup every 15 minutes JOB is created or not ? Thanx in advance.

Is there any tool available by which one can calculate (a)the size or a single row in sqlserver (b)the amount of traffic hitting the sqlserver

Is there any tool available by which one can calculate the size or a single row in sqlserver. This would really help in calculating the expected size of DB. Further one option can be to use sp_spaceused but it gives the details of the whole table… what we want is the size of a record […]

Mirroring , Log shipping SQL Server 2005

I am tasked with setting up a disaster recovery for one of our system. The primary server is in FL and the secondary is in Germany. The application is a global application within my company. I am not sure if I should use Log shipping or Mirroring. What I have read is that mirroring will […]

how to convert an SQL server 2005 .mdf to SQL server CE .sdf?

HI , I created a project where it can work with SQL server 2005. Now i want this project to be migrated to SQL server CE 3.5 which will run in low config system ( XP , 500 MHZ and RAM 488) How do i convert my .mdf to .sdf .I used third part tool […]

Formatting a Datetime returned from a SQL UD Function

Consider this simple user defined function: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [dbo].[ufn_GetFirstDayOfMonth] ( @pInputDate DATETIME ) RETURNS DATETIME BEGIN RETURN CAST(CAST(YEAR(@pInputDate) AS VARCHAR(4)) + ‘/’ + CAST(MONTH(@pInputDate) AS VARCHAR(2)) + ‘/01′ AS DATETIME) END which when run using: SELECT [Business].[dbo].[ufn_GetFirstDayOfMonth] (’03/13/15’) Returns, 2015-03-01 00:00:00.000. Fantastic, exactly what i wanted. Now suppose […]

Basic management scripts that you run in your database / instance?

What kind of basic management/audit scripts do you run in your databases or in an instance? There may be lots of them, but I would like to know (get hints) what kind of task would be most valuable when managing databases or an instance. And also what kind of reporting do you have from your […]

Database mirroring and replication on SQL Server 2005

How can I configure my mirror database to publish its data to the same replication database that my primary has ( I need to take my primary database offline for maintenance purposes.)?

Select non duplicate values from rows that are less than a specified number of minutes apart

I have a huge table with the following format: DATETIME NUMBER ————————————– 2009-03-31 16:05:52.000 2453651622 2009-03-31 16:16:12.000 30206080 2009-03-31 16:16:16.000 16890039 2009-03-31 16:16:28.000 2452039696 2009-03-31 16:16:33.000 140851934 2009-03-31 16:16:51.000 2453120306 2009-03-31 16:16:57.000 2453120306 … 2009-04-01 21:15:24.000 2453651622 How can I select the rows that don’t have duplicate numbers in the second column if they occur […]

Login failed for user ''. The user is not associated with a trusted SQL Server connection

My web service app on my Windows XP box is trying to log in to my sql server 2005 database on the same box. The machine is part of a domain. I am logged in in the domain and I am an admin on my machine. I am using Windows Authentication in my connection string […]

SQL Server Mangament Studio 2008 unable to connect to SSIS packages on SQL Server 2005

I get an “Class not registered” error whenever I attempt to connect to the integration services on sql server 2005 from within SQL Managment Studio 2008. Is there a workaround? or do I have to downgrade to SQL managment studio 2005?

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