You guys are right (but not 100%). If I tell you the stories (which are not stories by the way) about job termination on the spot & criminal cases against...

Few quick checks:

•Can you ping to Server (VM)?

•Please verify the firewall. You need to add exception for default port 1433.

Now it’s either a big mistake on my end or over-cautiousness because I work on Financial Projects.

When I read the membership id (16 digits) I interpreted it as ‘Membership Provider’...

By default, SQL Server installation will be:

•In Windows Authentication Mode

•SA disabled

•And admin rights were given to only one account (user who installed SQL Server).

Saying all that, you need to request...

Sean, do you really think the credit card validation criteria would be this simple & available to public to hack / mimic? Luhn algorithm is just a part of validation...

I like JLS solution because it’s sleek. However here is another version for simplicity (takes care of negative numbers as well)...

/*

158.94 should give me 158.90

158.95 should give me 158.95

158.96...

There are predefined algorithms for generating & validating credit / atm cards. IIRC, Each financial institute has only one predefined & unique algorithm for their use. Sequential number even if...

This is what I do and most of the times it works well:

•Uninstall SQL Server

•Delete the root folder (SQL Server application root)

•Reboot the server

•Clean the orphan entries with Registry Cleaning...

I agree with Jayanth. You can choose SSAS as a start-up option. Please download SQL Server evaluation edition & practice on SSAS & SSRS. There are few open source &...

I missed to highlight the correct sentence in my last post (and yes, the note about Unicode as well).

For non-Unicode data types, data comparisons are based on the code points...

So total time for this operation would be SUM of following:

•Time to Backup at source server

•Delay between backup & copy

•Time to copy the database backups to target server

•Delay between copy...

sp_createstats

http://msdn.microsoft.com/en-us/library/ms186834.aspx

DBCC SHOW_STATISTICS ( table_or_indexed_view_name , target )

http://msdn.microsoft.com/en-us/library/ms174384.aspx

UPDATE STATISTICS table_or_indexed_view_name

http://msdn.microsoft.com/en-us/library/ms187348.aspx

More: http://msdn.microsoft.com/en-us/library/ms190397.aspx

File System Task

http://msdn.microsoft.com/en-us/library/ms140185.aspx

select cast('' as numeric) some_column -- blank

some_column

---------------------------------------

Msg 8114, Level 16, State 5, Line 1

Error converting data type...

ROUND ( numeric_expression , length [ ,function ] )

http://msdn.microsoft.com/en-us/library/ms175003.aspx

CEILING ( numeric_expression )

http://msdn.microsoft.com/en-us/library/ms189818.aspx

FLOOR ( numeric_expression )

http://msdn.microsoft.com/en-us/library/ms178531.aspx