There is a nice article on this site with this information;

http://www.sqlservercentral.com/articles/Administration/2988/

also

http://www.sqlservercentral.com/articles/News/3036/

There are a few ways to do this, but they either involve restarting SQL server or making sure that there is no activity happening on the tempdb database. ...

this part of the code could be fixed up

And Tr.Time = (Select

...

You are using GROUP BY but have no aggregate funcitons in your select statement.

If you are doing this to remove duplicates, then try using

ROW_NUMBER() instead.

didn't you give the same answer as Rajan John after him? 🙂

but i do agree..

you said 360 rows, do you mean 360 tables?

Exporting 360 rows should not be a problem.

what is the exact error message you get ?

I agree with Gail and strongly recomend using stored procedures, this way you can be sure what is getting added to your database.

There are numerous ways to inject sql, and...

It depends on how you have your system setup.

The way I do websites, and most applications, is to only allow the application acces to stored procedures which can add...

The best way to do this would be to use variables in your stored proc

instead of

insert into table1 (query)

values('select replace('select * from table 2 where something in ('a', 'b', 'c')',...

There is a lot of information on this site and others about stopping sql injections do a bit of research, but basically;

-paramatize your queries.

-use stored procs.

-restrict access to stored procs

-remove...

Are you able to explain what the exact problem is?

I am reluctant to check out your (infected) site from work..

Or look at the values in the brackets next to the server name in SSMS Object Explorer

Sorry i did not fully appreciate the FTP part of the problem, if you had direct acces to the file paths you could build up a batch file to...

Thanks for that will have a look around msdb.

Does anyone know of any good db documentation for msdb?

i have looked around BOL and google but can't seem to...