You have to use the overwrite flag if you are using the GUI or the "with replace" option if using t-sql. Make sure that you are chosing a different name...

I think Idera has a tool similar to that in the Admin toolset. Not sure which tool it is but it was similar. MS SQL Health and History also collects...

No movies that I know of. Here is an article from msdn - http://msdn.microsoft.com/en-us/library/ms184252(SQL.90).aspx

Read the topic and the sub topics and this will get you started. Post back with more...

It relates to Windows server, not file server specifically. Did you see something in that KB article that made it file server specific? Curious.

It would be best to google information on RAID levels and database files. You will need to understand your activity type for your databases and then you can pick the...

Sorry for the misinformation. So, are you trying to pass through security information from the connecting user - or just from the web site - to the database?

From BOL

Logical reads - number of pages read from the data cache

Physical reads - number of pages read from disk

To reduce reads you need to look at a couple of...

and the link to Andy's article is - http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/

I believe it was Andy Warren that walked through this years ago on this site but you can use a neat utility to build and test your connection string right...

Which processor? If it is the first processor that is because the standard configuration for Windows is for all network traffic (and I believe it considers SAN fabric communication in...

Try using UNION ALL as just UNION will combine results and remove duplicates.

Nothing should blow up AND you get to take care of those things that are using the SA account inappropriately all in one swift change. :w00t:

That is exactly what I did and it worked fine. The following code is the brunt of what I used to get this working. Hope it helps. In your case...

Interesting and weird....

Michele - did that work? Very curious.

It should be as simple as changing the setting at the instance level. Make sure that you have Windows Accounts that are in the sysadmin group prior to executing the...