Rather than Copying the Database Copy from SQL 2012 to SQL 2008, please try import/ export utility & transfer the Tables Views & Functions....

You can also use Generate Scripts...

I need to know some information on below points..

1) SQL SERVER Installation & DB Creation

2) Hardening

3) Installation of required Tools like SQL Doctor, SQL APEX Tool for Audit, Recovery etc

4)...

Nothing like that..

Customer just want a Project plan on existing environment we have..

and have asked us to come up with do & dont's on DB server..

Like following standards, what can...

Sure Gail, Incase of any query i will reply here.. thanks for Update 🙂

Gail, actually i have never worked on Triggers & audits & so looking out details in google..

But didnt get any good documents for this... so me scared to implement

Lowell (8/27/2013)

---

I suspect the core issue is that everyone logged in has sysadmin or dbo priviledges and instead of fixing that as gail implied with proper security, you are...

Jason.Reeves (8/27/2013)

---

Why would you be interested in the IP address if your using DNS and DHCP. Have a play with

SELECT

conn.session_ID as SPID,

conn.client_net_address as IPAddress,

sess.host_name as MachineName,

sess.program_name as ApplicationName,

login_name as...

Anything for SQL 2008????

48 viewed and 0 replies :w00t:

Deg,...

That i am not sure.. coz the developers need help & so they asked us whether we can provide the solution to them..

They have optimized the query .. still deadlock...

Hanshi One more question on this...

Consider below scenario

Day 1

Full Backup

Log backup every 3 hours

(I have 1 Full backup & 4 log backup)

Day 2

Full Backup

Log backup every 3 hours

(I...

Sure thanks, once i come across any query in 2008, i will be using this 🙂

I need it for Both sql 2005 & 2008

For 2005 - What should i do???

For 2008 -

Well should i paste the output of first query in to the next...

The url states

to activate DBCC trace

=====

DBCC TRACEON (1222, -1)

=====

Well how do we deactivate it? as this cant be kept on for long period i think