Full Text was not working out of the box with Express then the developer in the link below provided the code solution so Microsoft added it with service packs but...

“Tony Rogerson in particular has a very interesting post on the procedure cache and how you might improve performance with application design,”

The SQL Server procedure cache is one of the...

I have used VS2005 for development both with Oracle and SQL Server without problems, strange the integration with Oracle both 9i and 10g was smoother than SQL Server in team...

You are getting the error because SQL Server 2005 is more ANSI SQL compliant FETCH per ANSI SQL definition is an implicit transaction and 2005 implemented it.  There is a...

Actually the correct place to start all the services is not Management Studio but the configuration manager where you can turn on services or turn the services off.  So go to...

Express does not come with FULLTEXT but developers added it through code so Microsoft relented so I am not surprised it is not populating the catalogs automatically which means Microsoft...

Lets be reasonable here, checkout the thread below and you will know why DBAs are leaving.  The person thinks someone can spend two days at their shop and DBA related...

I would think ADO.NET maybe trying to drop a regular table which takes a long time, options see if you can use derived table or table variable.  Another option wrap...

I developed on a remote SQL Server with DBO permissions for the last few months, I have browser service enabled in the surface area configuration tool, I also have allow...

If you go to the location below in your C drive you will see all the ready to use databases Microsoft Asp.net team created for web developers that they can...

No I am not saying that, the AppDataFolder let developers use MDF to create databases and add tables and other objects during development in Visual Studio.  During deployment the database...

I will not say Microsoft is the cause of the problem because technically it is not a problem it simplifies the development of web application because the AspnetDB can be...

(If all these outside vendors were IT departments within the customer's own organization, people would have (should have) been fired.)

Actually no because the database was placed in what VS2005 calls...

I don't think there is an automated way but VSS keep track of .sql files moved into it from your last deployment but you still need to send the excel...

There is no UTF8 in SQL Server but even 2000 will accept UFT8 from a client application because the .NET FCL(framework class library) Char is UTF16 by default but developers...