I am not sure why it is missing but, I found the type being refrenced in the SysAlerts table as Event_Source. Please review the sp_helpalert, you will find that this...

Looks like you are running your SQL Services under Local System Account rather than a domain account which causes it assume ST-INFO/SYSTEM as the user running a job. You have...

The official recommendation sounds more generic and may be well suited for the servers running with high memory (>3 GB). As the use /3 GB and /PAE switches with fixed...

Unless you are sure that, you do not have any Sprocs or other code elements expecting the columsn in the previuos order of the table, you venture it. As mentioned...

The best way to change the database connection in the DTS pacakage at run time is using .UDL file. If you define a DataLink task at design time and supply...

I cannot explain the reason for the problem but I have used a work around to fix it. The uninstall may not be finding the setup.iss file generally found in...

Welcome to the club and good luck with SQL Server. You may find less complicated and easier to manage than a mainframe

-Sravan

Hi Allen,

Looks like both of our links are pointing to the same technet chapter. But your link has more info orgainzed in one place.

-Sravan

Here is the modified script, it works. I have changed the joins a bit and took out the c.xtype = 'U' clause. Syscolumns.xtype is a numeric value indicating the datatype...

Rgahu, the bottomline is you have to have the rights on your exchange server "Send As" to send SQL mail. That permissions can be set at Exchange Server, aren't they?...

Here is a good oveview document from Microsoft. There are other resources on the web for these Migrations too. I have done similar Migration and it needs some custom scripts...

Database Design/implementations lot of times comes down to the culture and style of the oragnization and DBAs. Having 400 tables makes it cumbersome to model it and change management. It...

You can do so by either adding an additional step to the job or within the same step to query the tables to get the count. Then send the results...

Hi Raghu,

Your problem description fits the following MS KB article. The account which is configured to run SQL mail (SQL Server) may not have the rights "Send As" on the...

Sure TempDB is recreated everytime SQL Server is re-started but, it will recreate wherver the location of the files have been specified. Lot of times it is a good idea...