/3GB will work for RAM equal to 4GB or more & less or equal to 16GB. anything above 16GB PAE is applicable & you need to take out /3GB switch.

i...

Thanks for your reply, it got resolved before i got feedback.

thanks

There are many ways to write the connection string, but below is one example.  In this example 'ServerA' is the principal, 'ServerB' is the mirror, AdventureWorks is the database when...

Based on what you posted you are developing Web apps using Cold Fusion using JDBC Driver instead of ODBC or OLE DB. Can you provide complete error message or minidump...

can you put the complete error message or there should be minidump for this Exception Access Violation.

Are you trying to create SQL MAIL MAPI Profile or ?

The reason you cannot restore/attach database of SQL Server 2005 to SQL 2000 is beacuse of Database version.

Database version in SQL 2000 is 539 & SQL 2005 is 610 so when...

create job in SQLAGENT which will execute DTS1 & 2 every 10 minute. i hope this helps

See if this link helps you.

http://msdn2.microsoft.com/en-us/library/aa258746(SQL.80).aspx

As we know that default is "read commited". but if your front end issuing some adhoc/dynamic  sql statements/queries with isolation level, then it depends what isolation level is been used....

I assume by today my update document will be published on this website about DPM & i hope this will answer all of your most question. thanks for your time...

I have submitted the same article again with some more correction & good grammer and let see how soon it will be replace. I apology to the readers of this article...

Talk to your SAN guy to provide you SAN logs, that will be very helpful.

If latch activity is higher than expected, this often indicates one of two potential problems. First, it may mean your SQL Server could use more memory. If latch activity...

here is the article which is slight different but will give you basic idea.

http://www.sqlservercentral.com/columnists/jDave/2963.asp

thanks.