Also, you may want to bookmark this, it is the SQL Server 2012 Books Online on MSDN:

https://msdn.microsoft.com/en-us/library/ms130214(v=sql.110).aspx

You really need to read this:

https://msdn.microsoft.com/en-us/library/ms186858(v=sql.110).aspx

sql-lover (5/15/2015)

---

Lowell (5/15/2015)

---

i often get a similar error message when i create a new linked server, where i forgot to set the rpc and rpc out to true;

Executed...

briancampbellmcad (5/15/2015)

---

With the first block of code I get this:

Msg 3201, Level 16, State 2, Line 1

Cannot open backup device '\\belmont\c$\BCC_DB_backup_201505030017'. Operating system error 2(The system cannot find the file...

Try this:

RESTORE DATABASE BCCrestore

FROM DISK = 'C:\BCC_DB_backup_201505020017.bak'

WITH MOVE 'BBC' TO 'D:\Databases\Data\BCCrestore.mdf',

MOVE 'BBC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf';

GO

If that doesn't work because BBCrestore exists, try this:

RESTORE DATABASE BCCrestore

FROM DISK...

True,...

What are the data types you are using?

Jeff Moden (5/14/2015)

---

Luis Cazares (5/14/2015)

---

You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the...

You could also do this since this a SQL 2008 forum:

SELECT REPLACE(CONVERT(varchar(11), DATEADD(MONTH, month_adjustment, current_month), 106), ' ', '-') AS column_name

FROM (

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()),...

bpsavi123 (5/15/2015)

---

Hi,

i have task where i need to update the 2 columns from 2 different tables.I need to get one column from one table and update to the other table.If...

matthew.hudsonbryan (5/15/2015)

---

Hi,

I was going through some MeasureUp questions and one of the answers stumped me.

The sequence to restore for the answer to a question was.

Perform tail-log backup.

Restore Sunday 2:00 A.M....

asushil (5/15/2015)

---

Interesting Solution way back i was looking such solution for printing bar Code Labels for given no of item for given number of times.

some expert gentlemen on MSDN...

Jeff Moden (5/14/2015)

---

mw112009 (5/14/2015)

---

no did not work.. Since this was an link to an Oracle database.

However I found it while googling...

Select top 100 * FROM CDRQ_Moderage..[CDR].[EEG_TEXT_T]

This works! :)...

kiril.lazarov.77 (5/14/2015)

---

Thank you so much for your help.

I'd appreciate if you could show me how to overcome the issue when there are +2 missing records. So if there is...

When you granted the user sysadmin server permission you changed the users default schema from dw to dbo.

You need to add the schema name to the name of the tables,...