dma (9/11/2009)

---

If you dont read SQL books or attend worthwhile courses how on earth do you keep up?

And the stories on employer thinks you are attractive to recruiters because...

sp_refreshsqlmodule is in the master database

Sumanta (9/14/2009)

---

Thanks for the reply.

So can I come to conclusion that if I change the time settings in windows, the same will be reflected in the SQL database. There is...

prajeevan (9/14/2009)

---

failed installation of the SQL server 2005 service pack 3 due to login issues at the installation step.

pop "message is your account information could not...

Sumanta (9/14/2009)

---

Hi,

I am using SQL server 2008. Now I need to change the time zone in DB sever as per the country. Con anyone answer me the following queries.

1. How...

Maybe so, but i liked Gianluca Sartori's post. and the previous post gave a pretty good explanation.

ramyours2003 (9/14/2009)

---

the jobs faile ddue to

Error string: Could not run BEGIN TRANSACTION in database 'Portalreport' because the database is read-only. Error source:...

ps (9/13/2009)

---

Scripting should ideally bring job steps as well.

There is another method... Import the table contents of sysjobs, sysjobsteps and sysjobschedules tables from msdb database of the source server to...

Thanks for sharing.

ROFL, you can...

sarath.tata (9/14/2009)

---

Hi,

I have got two strange issue on my database:

Scenario:

I have a stored procedure mySP, which has a select query that JOINs two tables, say T1 in the current database...

shanikasuwaris (9/14/2009)

---

wt i need to do is to merge 2 different databases like oracle and sql server.. how can v do this.. any related article would be highly appreciated..

thanks...

You dont mention the version of sql server or the build. there could be a fix perhaps?

Without seeing execution plans, it is hard to suggest anything. if you can post more details it would help. just out of curiosity, how different is the new hardware from...

If it is a backup...