I think this is what you need

Select Count(distinct slr_id)

from gdw_tables.DW_CATEGORY_GROUPINGS g, gdw_tables.dw_lstg_item l

where g.site_id = 3 and g.USER_DEFINED_FIELD1 IN ('5', '7', '41') and l.success_yn='Y' and l.auct_end_dt >= dateadd(month,-3,getdate())

and l.leaf_categ_id=g.leaf_categ_id and...

A quick follow up. I used one of the built in reports to find when this was happening. I right clicked the DB and went to reports/disk usage. Underneath the...

yeah, It actually started a week ago. I manually shrunk it today, but I was trying to figure out why it would not reclaim the space.

try searching the web for metadata repository. there are third party products des8igned to do exactly what you are looking for, plus more, such as data lineage. we started our...

There is absolutely no harm in backing up to the same file. to read the contents of the file - do a restore headeronly from [backupdevice]

it will list all the...

we have tripwire and it's database name is tripwire. I suppose it's possible they named it something else. some table names in the database are:

ACLS, aele, alcatel, alcatel_config

You could write...

are you not able to use a job for this?

a good starting point is to load up the sql 2005 upgrade adviser. This can point out problems that can occur so you can fix them in advance to your...

it could simply be a matter of having a lot of unused space, in which you could just shrink the database to reclaim the unused space. Again, I would go...

it all depends on what kind of load is being put on them. I would look at your system resources to determine if another server is needed, or if you...

select transdate,case when amount > 0 then amount end as amountin,case when amount < 0 then amount end as amountout from payments

try ssis package store as your source

try this

declare @returnValue varchar(50)--make the datatype match your output

EXEC @returnValue = A.master.dbo.sp_CreateObjects--assuming your crate objects is in master database on serverA

try this:

sqlcmd -S db2000 -d p2000 -Q "SET NOCOUNT ON SELECT * FROM dbo.table1" -s "|" -o "c:\table1.txt" -h-1

I use the steps outlined here:

http://support.microsoft.com/kb/246133