Hi

Declare @temp table (Rid int identity,Name varchar(50),fdate datetime, todate datetime)

insert into @temp

Select 'A','10-12-2010','10-18-2010'

Union Select 'B','09-06-2010','09-13-2010'

Union Select 'C','08-30-2010','09-03-2010'

declare @i int ,@diff int ,@k int ,@Name varchar(50)

set @i=1

While @i<=(Select COUNT(rid) From...

Lowell (10/6/2010)

---

looks like version 4.2 is for "all" versions of SQL 2008; no special version just for SQL 2008 R2:

there are two different downloads for 2005 vs 2008 though, both...

gmamata7 (10/6/2010)

---

I'm sorry!!!

My question is wrong. Actually, I'm trying to restore a SQL Server 2008 database backup into a SQL Server 2005 instance and getting the error above mentioned. Is...

cbalasuriya (10/6/2010)

---

Hi All

Can someone please tell me if value1 and 2 are on same table how to get a result sets similar to

F ---> A and A ---> B...

hi

Try with this

RESTORE VERIFYONLY

from disk = 'D:\Backups\MyDB_10-06-2010.BAK'

Your version of SQL Server may be a lower version than the client's and a restore to a lower version is not supported.

The...

laddu4700 (10/6/2010)

---

Hi,

In our development server, I want to give only read and execute permissions to developers. I was checking below two database roles. But I don't want my developers to...

barry.smallman (10/6/2010)

---

I have a stored procedure, which is inserting rows into a particular table, I know that it runs once a day, but I cannot find the SQL Agent job...

LIYA (10/6/2010)

---

Hi All,

i have a table with following structure

CREATE TABLE [dbo].[DateFormat](

[WDate] [smalldatetime] NULL

) ON [PRIMARY]

insert into DateFormat

select '2010-06-18 07:33:17' union all

select '2010-06-18 07:40:18' union all

select '2010-06-18...

Alvin Ramard (10/5/2010)

---

I don't think you'll find one source that has examples for everything.

There's a number of books that are good references for what you're looking for. If you're...

Hi

Thanks for your response,i need to have examples for each and every item, this will come under help itself but. I...

pankaj.kuchaliya (10/5/2010)

---

Hi,

I have some doubt about , how to save the query output in excel file.

suppose when i fire this query from query window.

select 1 as 'd','pankaj' as 'name'

then...

Hi,

By default, msdb uses the simple recovery model. If you use the backup and restore history information in msdb when you recover user databases, it is recommend...

Hi

How about this...

Hi

Try this out

CREATE PROCEDURE usp_DiskFreeSpaceAlert

@DriveCBenchmark int = 1024,

@OtherDataDriveBenchmark int = 2048

AS

-- This procedure sends out an alert message when hard disk space is below a predefined value. This...

Hi

Not clear what you are trying to ask but to find the current identity of the table use

declare @tablname varchar(100)='CustomerInfo'

Select IDENT_CURRENT(@tablname)

if your need to added assign...