select *,case when (fname is not null) and (lname is not null) then fname+'.'+lname

else isnull(fname,lname)

end AS employee_Name

Well then you will need to write a command line based application which interfaces with SQL SMO and script out your database to a file.

As detailed, do a search for...

Do you have a script in the location c:\script.sql which contains the database schema and data to create a new copy of the CZ database?

Or

Do you want to export the...

Yes, but if you read the whole thing, you will see that Pinal Dave has run the SSMS GUI tool, saved the file as c:\script.sql and is then using the...

I have that in paper back edition.

I have not had time to use it yet as things on 2012 for us have slowed down quite a bit, but I also...

They you need to look at writing a command line program which interfaces with the SQL SMO objects to pull out the DDL of the database.

You could as well, depending how often you read the default trace and its limited storage space, create a custom proc which loops through the system tables and dumps the...

Do you have the deadlock XML in the error log, should be many many lines that looks like this

<TextData><deadlock-list>

<deadlock victim="process53b9288">

<process-list>

<process id="process53b9288" taskpriority="0" logused="476" waitresource="KEY:...

If they exist on the same instance no, use cross database queries

Like the following.

INSERT INTO DatabaseA.dbo.Mytable SELECT Col1, Col2 FROM DatabaseB.dbo.MyTable

If the database was on a different server, then yes...

Default Trace - A Beginner's Guide - http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

If the event is no longer in the trace then and you dont have auditing like DDL triggers, extended events setup then your...

Is everything on the local LAN or do you use a hosting provider for your SQL environment?

If everything is local, install just the client on the users machines and ensure...

-i is an input file which means you want to use that file to run it against the DB, not that you want to script out the DB to the...

Yes, or downgrade your secondary to 2008 R2.

Do you have traceflag 1222 enabled?

If so can you post the deadlock graph from the error log

If not run

DBCC TRACEON (1222, -1)

and then post the graphs once a deadlock has...

Yes, 2008 R2 to 2012 will work, but it can only be used for 1 way, once you make the 2012 instance active (WITH RECOVERY) you will no longer be...