Are you sure? When I try to use SSMS to...

Instead of having BusinessId_BusinessMember and BusinessId_BusinessGroup in the BusinessGroupMember table, couldn't I just have BusinessId in BusinessGroupMember table and use that column as part of the foreign key to...

The message 'Msg 8152, Level 16, State 14, Line 3 String or binary data would be truncated.

The statement has been terminated." is caused by the value attempting to be inserted/updated...

If you collation is Case Insensitive, then to only update rows when values would have changed, the SQL needs to cast to a Case Sensitive collation:

AND CAST( Import_Data_Fixed.LocationMixed as varchar(100)...

SQL Server available encryption functions do not include SHA2 or SHA256

Available are DES, Triple DES, TRIPLE_DES_3KEY, RC2, RC4, 128-bit RC4, DESX, 128-bit AES, 192-bit AES, and 256-bit AES.

http://technet.microsoft.com/en-us/library/ms345262.aspx

Perhaps I am missing something but what is wrong with a solution that has no cursors, whiles or UDFs ?

use tempdb

go

Create Table Import_Data_Filter (MyID Int Identity(1,1) NOT NULL, Location varchar(100))

GO

Insert...

It depends if what you have listed as the "_pk" columns. If these single columns, then yes, this is a circular reference and can be a problem since declarative...

In order to avoid loss of information, all literals need to be prefixed with N and all variables need to be defined as nchar, nvarchar and ntext. Variables includes...

You seem too have two requirements:

1) Update all “Part Price xx” fields in the “Products” table.

2) Report all “Part No xx” that do not exist in the master parts file

Suggest...

The TargetServersRole role is defined with deny execute on procedure sp_start_job and as deny overrides any grants on the procedure from all other roles, a user with TargetServersRole cannot start...

There are some constraints with the solution:

1. The second transaction log needs to be on a different drive that...

The simpliest solution is to add a additional log file on another drive, backup the log, shrink the first log file and then remove the additional log file. Here...

Perhaps the drive partitions housing the tempdb files are not aligned? See "Disk Partition Alignment Best Practices for SQL Server" at http://msdn.microsoft.com/en-us/library/dd758814(SQL.100).aspx

If SQL Server is running on a Cluster and certain other conditions apply, such as VPN, then this is a known bug.

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/27/unable-to-connect-to-a-sql-server-named-instance-on-a-cluster.aspx

Using the IP address, the source domain can be determined from the 'American Registry from Internet Numbers" at URL https://ws.arin.net/whois/ or http://wq.apnic.net/apnic-bin/whois.pl

The four IP addresses are...