You can create an SP using xp_sendmail .Finally create a job that executes daily before you come to office and send you the mail .In xp_sendmail you can use the...

Your very welocme ....

I left the SQL Server team in Microsoft (Bangalore) last month and joining IBM now ..

Regards:-)

Yes its possible :

1) install SQL Server 2008

2) open the management studio

3) in the toolbar go to view >> select Registered servers

4) in the database Engine section you will...

by default for every new connection the master database is opened and then we use "USE " to go to a particular database .

The other way could be to change...

Would like to add 2 cents here .

If you execute them serially in one job ,it will take more time .

You need to calculate that time and if its acceptable...

1) If only the readonly SPIDs are getting blocked then it will do wonders for you .

2) if you have a bit of write as well , still it will...

You cannot do it directly .You need to convert it to varbinary first .

begin

declare @num nvarchar

set @num = 'hello'

select cast (cast(@num as varbinary)as int)

end

Hope this example helps as you have asked a general question and not given any other information :

begin

declare @num int

set @num = 22

select cast( @num as char)

end

1.Is the SQL Server insatnce restart every time we move the groups from one node to other? Because I'm seeing in the error log that the sql server instance has...

Linked server will not serve that purpose my friend .

sorry , you can also create a temp table #test

Regards

1)

create table test

([name] sysname,db_size nvarchar(13),

[owner] sysname null,[dbid] smallint,

created nvarchar(11),[status] nvarchar(600),

compatibility tinyint)

2)

insert into test exec sp_helpdb

3)

select name ,db_size,owner from test

HTH

SQL Server works on the principle of proportional fill .The data will go in all the 3 files in such a way that all the files get filled at the...

Ian is correct .

The reason behind it is :

When you make any changes in sp_configure , the updates are recorded in sys.configurations view (actual table is in mssqlresource which you...

You got the answer .Aliases are always created on the client machines .

On the localhost you have both clients and server .

Regards