the error tells what the issue is, but it might be a little new to you for debugging these kinds of issues.

to really help; we'd have to see the code...

Kris if you alter...

dtipser (4/26/2010)

---

Hi,

Yes, I created the index, but after that is asking to create another one. For sure the statement run a litle faster but it still doing some scans in...

Developer 2005 (4/26/2010)

---

Thanks

u are right

but we don't want to send mail to all user.

i want to pass a message in message box and want to display on screen of...

search your MSSQL.1mMSSQL.2 and MSSQL.3 folders for *.mdf files.

with luck, one of those files should be the name of your old database.

once it, you will copy that MDF file along...

hansel i'm not sure what you are doing...

sysobjects in SLQ 2000 contains the metadata of all the objects in the database, including the tables; you can join sysobjects to syscolumns...

i actually can see how that is a good idea; some views pulling together a lot of stuff shouldn't be ad hoc queried;

I like the idea.

i might actually rename some...

Oleg good catch! that's the diff between using datepart and calculating elapsed time; i'm fiddling with it now of to test for accuracy;

Thanks!

::edited; i think this seems to calculate...

well the optimizer uses the stats to determine the fastest way to get the data; if the statistics imply that the selectivity of a record is very close to 1...

now that you have the two vals as datetime, it should be easy;

here's some examples i've saved that pulls out the peices; you can concat them togeter for the format...

statistics.

the statistics are different between the two databases.

even if the two db's started out as identical, the way the data is selected/updated can change the statistics, and THAT is what...

this one is just a basic error, no worries.

the issue is this part i think:

WHERE EMP_ID = ''' + @ZEMP_ID + ''''

you are doing VARCHAR + INT, which results in...

procs and functions are going to be the same logic; cursor with a try - catch, but instead a dynamic SQL;

get the text for the proc/function from sys.sql_modules, do...

I had looked into this same issue back in september;

see this thread here:

http://www.sqlservercentral.com/Forums/Topic785213-146-1.aspx

at the time, i was having some developers run scripts that dropped stuff, and then they found out...

do a select * from sys.servers

quite often, the alias for your linked server is different than the name of the actual server.

it's the name of the linkedserver, not the...