SPID 69 is updating Status table while SPID 77 is selecting the same table.

SPID 69 is holding IX lock on page 5:3:695694 and trying to lock (IX) another page (5:3:695693).

In...

Can be both and/or can be used in N-tier architecture....

If your client app is accessing SQL Server directly, it can be considered as 2-tier app.

If your client app is accessing...

How to shrink transaction log file: http://bit.ly/XaDOQr

SSMS has generate script wizard which exports all schema scripts and insert TSQL statements (if Script Data is true). The same/similar wizard (Database Publsihing Wizard) is available in Server Explorer...

1. What is the recomendation for analysys server configuration to put temp directory and back up derectory to which drive? http://technet.microsoft.com/en-us/library/cc281997.aspx

2. Is sa account for this installation needs to be...

I felt that smtp mail is kind of tricky sometimes since

different web hosting vendors use different mail policies...

http://webbeyond.blogspot.com/2011/09/send-email-in-aspnet-from-arvixe-web.html

http://webbeyond.blogspot.com/2011/11/godaddy-email-error-553-sorry-your-mail.html

SQL query data (or table) can be exported to Excel by using this handy tool.

Export SQL data to Excel

Another way might be you bcp out the data into .csv and...

AFAIK, Connection pooling is based on exact match of connection string.

If you use different application name, new connection pool will be created.

I think this is by design.

Right, connectionstrings.com/sql-server-2008 is a good resource.

Just FYI. Here is an example:

string strConn = "Data Source=(local);Initial Catalog=pubs;Integrated Security=SSPI;";

SqlConnection conn = new SqlConnection(strConn);

conn.Open();

// Do something here

conn.Close();

// Data Source=serverName

// Initial Catalog=dbName

Year() and Month() function returns int data.

.....

WHERE NOT EXISTS

(SELECT empid

FROM Sales.Orders

WHERE YEAR (orderdate) = 2007 AND <==

MONTH (orderdate) = 02) <==

Here is step-by-step procedure of how to enable FILESTREAM and how to use it from SQL and in C#.

How to use FILESTREAM

I think this is an interesting issue. Since Henry_Lee is talking about client protocols, not server protocols, SQL server recylcling is not required.

My understanding is that SSMS is trying...

This tool converts SQL table or SQL query resultset to Excel.

NULL will be replaced by empty string by default.

http://www.sqlmgmt.com/sql/Convert-SQL-to-Excel

Please refer to the following blog.

How to check SQL connection in Excel

If you want to save the SQL query result into Excel,

you can use this handy tool.

Convert SQL Table or Query Results to Excel file