I have an osql statement that queries a database.
If the query returns any rows I want them written to a file, so I redirected
the output of my osql statement to a file (results.txt). But if there are no
rows that comply with the condition of the query I do not want any files

Hello everyone
Within each database there is an icon called users, within that user
containner , you can see users has different permission for that database.
Is it possible to display a list of effective access rights for all users

I am trying to change setting ”NotForreplication”  across all FKs.  However
so far the only option is to drop each FK by name and recreate it.   I was
looking to create a script that goes through all FK and does the change.  I
am running SQL 2000, however in SQL 2005 I found ...

I am trying to change setting ”NotForreplication”  across all FKs.  However
so far the only option is to drop each FK by name and recreate it.   I was
looking to create a script that goes through all FK and does the change.  I
am running SQL 2000, however in SQL 2005 I found ...

I am trying to setup a script where I run an insert query to insert
information into a table.
The first part I have down pat as far as the Insert, where I'm having
difficulties is that the information is coming from an outside source and the

Is there a way that I would be able to know that the 2 CPUs in my SQL Server
2005 are both utilized?
Thanks in advance!

I am scheduling a simple job to run a query. I want the result of that query
written to a text file.
When I am scheduling the job, in the step section I am creating a step of
type "Transact-SQL Script (TSQL)" where I define the query. In the advanced

I've spent a few hours researching the datetime comparison, and from what I
understand, what I'm doing *should* be working... any help is GREATLY
appreciated.
I have a table that stores a column (EventDateTime) in the datetime format.  

I'm trying to run a query that produces data from three tables, in essence
these are Location, Category and BannerPeriod, They all have a secondary key
of SiteID and are linked by this, really there are two stages to this query,
Stage 1 produce a complete combination of all ...