That is cool!

It may be related to data as well. Reorganizing a physical order of the rows may push a bad row closer to the end of the table (in...

John,

I am glad it worked for you.

Yelena

Good Article.

I agree with Bryant Byrd who suggests running xp_cmdshell. I would run it as a last step to run a VB script to send SMTP email to a user...

To: lalibert16

Thanks Erik!

Yelena

Simon,

master will be able to start in the new location only if the startup parameters in the registry point to the correct location. For SQL Server 2000 it should be...

Simon,

If you are planning to implement the SAME file path on the new server including the drive letter you may be able to:

- Install the same service pack /patches on the...

Hello John,

when you say "I have checked that I have access to the port numbers used by SQL Server" do you mean 1433 / 1434 or you mean port numbers...

Hello,

I would advise to give a login to Windows group.

Then change the connection string to use integrated authentication, see http://www.connectionstrings.com for syntax.

Then use one of the following:

Select suser_sname(suser_sid())

select...

GPF2^192 and Remi,

Thanks for your replies!

I  looked up LaRonde  park and will plan something. Let me know if you if you may think...

Hello,

This is a good research work, thanks.

I would also add that when a database is restored / moved from another server the db owner changes in most cases unless it...

Remi,

Aren't you form Canada? I am planning my vacation, are you by chance anywhere close to Montreal ? I need an advice on what could be really entertaining for 12...

Hi,

You have to explicitly set the default database. It is different then giving an access to the database. In EM, login properties Default Database  is on General tab and Database...

Ian,

Did you try OLEDB driver instead of ODBC in VB? Go to

http://www.connectionstrings.com/

expand SQL Server and then OLEDB nodes. There will be a string that lets you to specify...

Hello,

If you do Start->Programs_MIcrosoft SQL Server and RIGHT CLICK the entry for Enterprise Manager and select properties it would show you a shortcut for EM. It is:

C:\WINNT\system32\mmc.exe /s "C:\Program Files\Microsoft...