Best is to capture this content for a while (to have persistent data)

select db_name(database_id) as DbName

, case db_id() when database_id then object_name(object_id)

else cast(object_id...

This backup of your database has been created using multiple backup files !

You need all files of that backup(set) to restore the database.

http://msdn.microsoft.com/en-us/library/ms186858.aspx

smtp & win2008 seem to have changes in setup compared to win2003.

Maybe this one helps ...

http://weblogs.asp.net/nannettethacker/archive/2008/11/17/mailsettings-smtp-network-windows-2008-web-server.aspx

did you enable dbmail xps

-- enable db-mail

exec sp_configure 'show advanced options', 1;

RECONFIGURE;

GO

exec sp_configure 'Database Mail XPs', 1; -- 0 to Disable and 1 to enable

...

- is your mail server accepting smtp from your cluster nodes and sql instances (may need grants at mail software level on the mail server)

- is sqlbrowser running ?

...

altering to varchar(8000) is only a catalog operation (and maybe an index op if the column is indexed) because it stays the same datatype, only the var length changes.

Changing...

Some samples (I'm not sure where I got them from) :

BEGIN TRY

-- Generate a divide-by-zero error.

SELECT 1/0;

END TRY

BEGIN CATCH

...

peleg k (7/28/2009)

---

BEGIN CATCH

SET @Err = @@ERROR

SELECT @ErrorMessage = ERROR_MESSAGE(),

@ErrorSeverity = ERROR_SEVERITY(),

@ErrorState = ERROR_STATE();

END CATCH

IF @Err...

As you suffered, any DRP should include your "day to day working environment" as well.

Don't you just love those 1TB usb disks 😎

Combined with a good Ghost software it...

CREATE LOGIN [MyAlternateSA] WITH PASSWORD=N'Super$ecr@PwD' , DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON;

EXEC master..sp_addsrvrolemember @loginame = N'MyAlternateSA', @rolename = N'sysadmin';

Great addition Lowel :w00t:

Now all OP has to do is copy/paste and hit F5.

One last remark, if these tables contain many rows and you cannot perfrom "truncte table ..."...

abhishek.c1984 (7/23/2009)

---

ok thanks for the reply....

Actually iam using hibernate, it will take care of such activities...

w.r.t your opinion i have create a sample JDBC connection as shown below, but iam...

use at your own risk 😉

You could use this to start with

Select 'Delete from [' + TABLE_CATALOG + '].[' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] where...

BP is always to specify the database name you want to connect to (don't rely on the logins default database ! A sql instance can host multiple databases !)

Check out...

abhishek.c1984 (7/23/2009)

---

thanks for the reply,

I have just executed the query in SQL Server 2005, it worked fine...but the database connection was broken

-------

Nonqualified transactions are being rolled back. Estimated rollback completion:...