@hein 50303

Unsure on PostgreSQL, you will need to see if it has tools like SSIS in SQL. If you have MS SQL on a different server, then just install...

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

SQL Licensing is version specific in a fashion, where you can downgrade but not upgrade.

So in this instance as you are upgrading from 2000 to 2005 you will need to...

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...