SQL Server Intergration Services - Basically the new and improved DTS in SQL 2005 onwards.

BCP would be an option

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Have you tried using SSIS with a web service task to query the website, then store it to a variable of type object, then use that variable as an insertion...

does excel sheet call a web service?

Edit

Duplicate post http://www.sqlservercentral.com/Forums/Topic1319084-359-1.aspx

The MSDB database will contain what you need especially the run duration column in sysjobhistory which is in seconds, then you just need to format it how you want it...

Log shipping is one way as you cannot modify data in ServerB while in a log shipping setup.

ServerA does the backup and stores the TRN file locally.

ServerB then opens a...

http://msdn.microsoft.com/en-us/library/ms186775.aspx

IDENTITY(1,1), means start at 1 (1,x) and add 1 (x,1) every time a new row is inserted

1

2

3

4

5

6

7

IDENTITY(100,200) means start at 100 (100,x) and add 200 (x,200) every time a new...

This should be a good read to get you started, but as everyone will say on this "It Depends"

http://www.sqlservercentral.com/articles/books/71809/

The only way would be to loop it into a xp_logininfo call to query the members of the groups, or into a LDAP query which goes and looks up in...

SSRS is Windows only authentication, if you dont have System Administrator access to the reporting services webpage then you cant login via SSMS to Reporting Services.

have the new servers been granted the nessesary access on the mail realy (smtp) server to send mail?

the account might have access, but does the server?

I have a job which sends a mail when SQL Agent starts, only problem is if the agent isnt restarted when someone restarts the engine, but as its in a...

Easiest way, create a load of AD groups, assign the people you want to them groups, then assign the groups the access they need in SSRS. That way you...

Well if you know you have 30GB free, then specify a size of 63GB as SQL will try to get it down to 0 or as close to it as...