Solve Above error by passing NULL

now this error i got

Msg 19062, Level 16, State 1, Procedure sp_trace_create, Line 1

Could not create a trace file.

Gewtting this error when running on sql 2008R2

Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 243

The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator).

Does it work with SQL 2008R2? or u have updated script?

Hi

Did you find out how to send query result in mail using SSIS?

If yes can you describe here?

i am working on this issues and not going through SSIS.

Thanks

Microsoft Upgrade Advisor article

http://www.mssqltips.com/sqlservertip/2184/overview-of-microsoft-sql-server-2008-upgrade-advisor/

run the Micrsoft toolSQL Server 2008 Upgrade Advisor than you will get very good idea.

working on your posted query and works fine .

Just one que is that in IsUserTransaction column whats mean for user transaction ? 0 or 1?

Excellent ,

very helpful

very helpful , works in SQL 2008R2 also

that's why it says No SSIS Included..

Also this can be helpful too

--Reference:

http://stackoverflow.com/questions/198478/advantages-of-ms-sql-server-2008-over-ms-sql-server-2005

SQL SERVER 2000:

1.Query Analyser and Enterprise manager are separate.

2.No XML datatype is used.

3.We can create maximum of 65,535 databases.

4.Nill

5.Nill

6.Nill

7.Nill

8.Nill

9.Nill

10.Nill

11.Nill

12.Nill

13.cant compress the tables and...

You can find out here

http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

Just simple XCOPY commnad copied backup file from network to local machine.

yes it runs fine from cmd.

Click View and underneath of view you can find it

To know the size of Index you can try this for particular Database

SELECT

i.name ...