As far as I know, there is no way to provide a database an alias name.

By the way why would you want to do this?

Just for the reason that your...

See if this helps.....had it in my archives........

SELECT

CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,

msdb.dbo.backupset.database_name,

msdb.dbo.backupset.backup_start_date,

msdb.dbo.backupset.backup_finish_date,...

Ashok,

go to the Surface Area Configuration settings under the Configuration tools of MS server 2k5 and select the Surfacr Area Configurations for features.

There go and select the one which says...

Hi Ashok,

I hope the following would be of help to you and also not too late.....

The option for enabling the mail option could be done by configuring the database mail...

ok an example with a cursor...

declare @userid int

declare insertcur cursor fast_forward

for

select userid from users

open inertcur

fetch next from inertcur into @userid

while @@FETCH_STATUS = 0

begin

--- put in watever...

OK......now from where are you getting these values for Stat and the others (except for the user id.....i know where that from thanks to the explaination).

If your requirement is to...

Please could you be more clear on what you wish to do? I cant make any sense out of it.

You could however find the transaction log at the following path

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Now most of the data would be stored in binary form is my guess....Recovery of the deleted...

God help you........

nevertheless, here are a few things you could do the next your fingers stretch to write a delete statement...

1. take a backup of the rows that are to...

First of all thank You John and Keith, u guys have found some serious flaws there....

Keith, i must say I completely forgot about testing my script for that one particular...

Carlos,

First of all, great SP there...but let me tell you why mine is quite different from yours.

1. Here my aim was to script the table s data in insert script...

Well just to put in query terms what wagner have just suggested

DECLARE @AllPhones VARCHAR(1000),@Count INT,@maxcount int,@mincount int,@codname varchar(100),@rowcounted int,

@Row int,@codename varchar(100)

SET @AllPhones = ''

create table #Results(codname varchar(1000), PhoneNo varchar(1000))

create table...

Why dont you make use of a variable/temporary table to put all your data into and then retrieve the data using select *......

I assure you its more easy and better...

Well written...

Although I do have a point to add on just for the sake of it.....Its concerning the limitation of the Merge Command.

"The merge command could be used only on...

A real good explanation by Simon....Im quiet clear on this one..Thanks Simon:)