I am glad I could help.

EDIT

Planning solves this problem because you define it as Big INT but SQL Server will only use Big INT when the values of INT is used up. Try the link...

(This is crux of the problem. I am getting an error message saying that I can't have both ShipToAddr and BillToAddr (both in Client update when address updates this causes...

You are confused by Microsoft documentation making simple subject complicated, what you are looking for is called DRI(declarative referential integrity) meaning if a references b then b must exist. To...

Yes your syntax is current but You just run both INNER and OUTER JOIN on the same tables, that does not meet the ANSI SQL definition of OUTER JOIN because...

You must be talking about the obsolete syntax but still used by SQL Server 2000 WHERE clause JOIN, I am talking about the current JOIN using the FROM and ON clause...

Here are some facts that may help you, there are two types of temp tables in SQL Server Local # limited scope and global ## longer scope but you must...

No there is nothing subjective about the question because there is just one answer that is the INNER JOIN because OUTER JOIN as he original poster stated default to a...

You need to do it now because character conversion happen with browser interaction with your program, I think you need to do it now when the database is small before...

(Both SQLAgent and MSSQL are running with Local System credentials.)

The above is the reason for your problems, Replication will not run when the Agent does not have access...

You should see the stored procedure being called in your .rpt file in Crystal Report because creating reports through stored proc is different from the other options like .NET or...

There are only 200 stored procs you can do it yourself, open you database in Enterprise Manager, go to Query Analyzer you should see all your stored procs in the...

Here are the steps Polish Collation for the database and columns and Nvarchar, NChar and NText for the data types.  If the application is .NET do Polish encoding in the application...

The features comparison link below shows you have some but not all the BI features so just rerun setup choose repair and when you get to choose components choose all. ...

If you are getting the problem with Varchar (max) then the Locale ID is important because it stores the overflow after a ROW in the file system of the OS...