You can us my script. It even gets you column names also.

http://www.sqlservercentral.com/scripts/Replication/31668/

but i am successful in uninstalling the hotfix cu1. you can just goto add remove program and click the remove button. But the same remove button was not available for...

sql service service account should have write access to the folder.

I think your sql agent cache is not in sync with msdb database. You can check this by running

xp_sqlagent_notify 'D', null, Null, null, null.

This will dump what is there...

http://msdn.microsoft.com/en-us/library/ms378108(SQL.90).aspx

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

Is that indicator is just a color box or is that contaning any text.

can you please put singel character there and try.

Can you please run the maintenance plan to defrag if any tables are fragemented and then run the dbcc shrinkfile to reduce the size

After installation dont stop yourself by verifying the summary.txt in the location

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix. it should say all success

try this

SELECT 'UPDATE STATISTICS dbo.'+ table_name +' WITH SAMPLE 50 PERCENT'

FROM INFORMATION_SCHEMA.TABLES

where table_name like '%ScheduleDay%'

I think you previously worked in Oracle scripting or in VBSCripting or c,c++ like that. You should explicitly provide the values for variables when you are calling

Can You post sql Agent Error log details.

This is the problem with xp_cmdhshell, here in your case i am able to see that your just calling the xp_cmdshell with file name without anyoperating system command(eg, del,...

But if you are not familiar with WMI or Powershell.

You can use

EXEC master..xp_servicecontrol 'QueryState', 'SQLServerAgent'

you can set a batch job for all your 100 servers and report the output...

It looks like your sql server security logins has a login Built\Administrators. Just remove that. But before removing ensure that you know sa password and add the service account exclusivly...

you can also think of indexing the temp tables created. As soon as the data is pumped data into the temp tables you can create index on these tables. This...