here is an example of a simple cross tab query.  Hope it helps.

SELECT  emp.LastName + ', ' + emp.FirstName AS 'Employee Name',

SUM(CASE month(orderdate) WHEN 1 THEN 1 ELSE...

Also, don't forget about the VPN option between your sql server and the web hosting site.  That keeps it more secure. 

I see your problem.  Opening your SQL Server to the outside world can be very dangerous.  You must make sure you lock it down as best you can at the...

Correct me if I'm wrong, but isn't the tempDB only resized at start up?  Your queries are probably doing a bunch of sorts which is filling up your tempdb. 

If...

I take it your database is already set up, which means there is no opportunity to set up a new drive array.  Now the database is running out of space,...

Looking at your request, the replace method is definately the best option.

Don't forget to make sure the agent has rights to the share folders that you set up. 

I'd recommend the linking method which enables the data to remain fresh.  I have users here that "copies" the tables and then don't understand about it being a snapshot in...

I'm not sure if I would use the SA account to start SQL Server.  What you may want to do is find out why the sqladmin account was locked out,...

William

In management studio, you can set default values in the column property section which appear on the bottom half of the work screen.  It does not appear until you are enter...

As far as I know the position has not been filled but I am no longer there

You need to connect to the integrations services engine.  Your package will be either under the file system or MSDB drop down from stored packages. 

Let me know if you...

Frank

I had to do it the old fashioned way utilizing import/export data method.  Right click on database, select tasks, then select export.  The rest is in the wizard.  Good luck

Marvin

You can simply type the delimiter character in the pull down box.  Let me know if you need any futher help.

Steve

I'd try an execute SQL task and assign that value to a user defined variable.  Then I'd set the connection string expression to that variable.  Hope this helps.