You can configure your two digit year cutoff so that it displays the correct century. http://msdn.microsoft.com/en-us/library/ms191004.aspx

It depends on the read/write ratio of your database. If you are mainly a read-only database (80% reads or more) then I would suggest your mdf file be moved over...

Ola Hallengren has already done the work for you. Check out his scripts[/url] for performing index maintenance and also backups and restores. These scripts are highly regarded in the SQL...

Don't make this harder then it needs to be. Either script out the "must have" jobs and then restore MSDB and reapply the jobs from the script or restore MSDB...

shiv-356842 (7/30/2014)

---

Hi Team,

For pre-paring report I need this format report on instance.

Database Name Database User Name Database User Permission

Request to you please give any ideas on...

Do you have a backup for the entire MSDB? If so, you can simply restore that over the new MSDB database.

ScottPletcher (7/30/2014)

---

Sean Lange (7/30/2014)

---

ScottPletcher (7/30/2014)

---

That's not...

You can create User Defined Data Types that had the necessary Null values you want defaulted for that data type, but you would have to use that data type when...

SELECT DISTINCT C1.IDX

, C2.C2FirstName

, C1.C1FirstName

, CASE WHEN CHARINDEX(' ',C2.C2FirstName) > 0 THEN PARSENAME(REPLACE(C2.C2FirstName, ' ', '.'),...

It is not required.

If you don't set the NULL option then...

You have posted 4 or 5 different times about this query. If you want it to work correctly please give us the all the create table statements (for all tables...

Please don't post the same question in multiple forums. Here is a link to the original http://www.sqlservercentral.com/Forums/Topic1586485-391-2.aspx#bm1586578

Please, Please, Please add the code to create the tables and some sample data along with the desired output. We are wasting time trying to guess what you want and...

I'm not sure what the question is. It seems like you have added the table are you not getting the results that you expect? If not, what are you getting...

Click on the word blog it is a link