refer to SQL Server Tacklebox by Rodney Landrum under the books section.

I was in a similar situation. Their were no FKs but the

PKs and FKs had a naming convention somewhat like

parenttable : ID PK

Child1: parenttableID FK

Child2: parenttableID FK

It took a bit...

I think that SSRS report viewer control doesn't exists.

please refer to the below links.

http://msdn.microsoft.com/en-us/library/ms251671(VS.80).aspx

and

http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en

yes..you can use the DMV sys.dm_os_performance_counters.

I also had a similar problem.

This is what that worked for me.

-SQL SERVER SP3 OR If KB953752 for SQL SERVER SP2

-Report viewer: http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D

Install the report viewer on web...

dba-vb (9/7/2009)

---

hi,

i've a database with full text enabled, by backing up this database,need to restore this backup to new database.

RESTORE DATABASE NEWDB

FROM DISK ='\\DBSERVER\OLDB.BKP'

WITH REPLACE

But it...

export the trace definition from profiler...i.e. select events and columns and apply filter in a profiler...and then File->export->script trace definition....

table scan....I think it will be index scan....and query 1 will give a index scan...

table scan....I think it will be index scan....and query 1 will give a index scan...

Silverfox (8/27/2009)

---

thierry.vandurme (8/27/2009)

---

total memory is 8Gb. SQL instance 1 is using about 7.5Gb of it. I suppose if we add memory it would even grow so can I assume the...

tpa (8/11/2009)

---

Yep, you could use a transaction like this:

begin tran

:r "C:\sqlscripts\01.script1.sql"

if (@@error != 0) goto endRollback

...

Is their a way to handle begin tran statement when executing script thru sqlcmd...

SanjayAttray (7/30/2009)

---

Sqlfrenzy (7/30/2009)

---

An easy way of executing scripts.....

Create a batch file and place it in the folder containing the scripts...

@for /r %%s in (.) do (echo ..............%%s /b >> "C:\Build...

An easy way of executing scripts.....

Create a batch file and place it in the folder containing the scripts...

@for /r %%s in (.) do (echo ..............%%s /b >> "C:\Build Deployment\output\Log.txt"

sqlcmd...

Dan Guzman (7/10/2009)

---

Sqlfrenzy (7/10/2009)

---

Dan Guzman (7/10/2009)

---

The post doesn't say which version of SQL Server this is for, but with my 2005 I got close to 30 errors, mostly syntax errors...