All your queries on how to play with excel and sql server (including linked servers) should be answered in this excellent article by Phil Factor and Robyn Page.

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Create a job, a job step (command to fire ur SP), and schedule it.

Thats too...

Hmmm.. Seems builtin\administrators have sysadmin role on your server.

opps!! i overlooked the forum (its sql 2000) and the links i mentioend contains reference to sql 2005...

THis site contains a workaround on this for both sqlk 2000 and sql...

Raul Garcia's blog contains an excellant article on this.

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

This post should help you.

http://www.sqlservercentral.com/Forums/Topic253723-5-1.aspx

Can you also post the table structure with sample data and the error you're getting.

This site should help you in posting the required solution.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Why cant i use function with UPDATE?

I tested that statement...

am (1/2/2009)

---

Guys,

update test14

set fname_bak = (select dbo.GetCharacters (t.fname, 'a-z') from test14 t)

from test14 inner join t on t.id = test14.id

go

I am failing at the last step which is update

'Msg 208,...

By nullify, do you mean delete all identity values and insert...

There are ample scripts available on this site on backups. Just go through them and modify them to suit your requirement. But make sure u've a good backup policy in...

"Industry Experience" - Here i'd call industry as IT industry and i'd prefer to have a real-life experience. I might have read entire BOL and other stuff, but chances are...

paulhunter (12/31/2008)

---

It seems strange to me that you're spending time trying to force sequential numbers on an identity column. As you have discovered, your identity column creates a unique...

Excellent way to prove the best performing query. After going through the explanation, one can easily make up his mind as how good queries need to be written.

Thanks Chris for...