Can you post the DSN configuration?

Can you please share the script you're using?

Here's a solution with UNPIVOT:

DECLARE @sample TABLE (

Username varchar(50) PRIMARY KEY,

column1 char(1),

column2 char(1),

column3 char(1),

column4 char(1)

)

INSERT INTO @sample VALUES

('ron', 'Y', NULL, 'N', NULL)

,('rob', NULL, NULL,'N', NULL)

,('rose',...

There is also the Enterprise Evaluation Edition. The license lasts 180 days and it is free.

After the evaluation period, you can decide whether you want to buy the Developer Edition...

Which connection error? Can you please share the exact error message?

Can you post the ODBC configuration?

Glad I could help

Tempdb contains internal tables and user temp tables. Both type of tables are by nature volatile.

Probably the corrupt pages were part of some object that got dropped.

Do you still...

I would do it one database at a time.

You should get that message when you're trying to connect with sqlcmd, not when you're starting sqlserver from the command line.

Welcome, glad I could help

You are getting the errors because the tempdb files cannot be created.

1. Open cmd impersonating the service user. Use runas for this.

2. Run services.msc to open the services applet. Find...

I used it a couple of times and it worked flawlessly for me.

I migrated a 2008 to 2012 and it had hundreds of reports. It took a couple of minutes,...

Or MCT

I don't see any errors in your CHECKDB output.

In order to fix your tempdb (if you can afford a 2 minutes downtime) stop the instance, delete all tempdb data and...

I would suggest studying 2014. Even if you take the 2012 exams you will have everything you need to know to pass them, plus something more.