reporting services must be installed on the same box as SQL to comply with the default licensing requirements, i think.

after that it's the usual cost benefit scenario.....most people recommend SQL...

after each update statement, check the @@ROWCOUNT value...it tells you the number of rows affected by the previous transaction.

with that value, you can logically decide what to do next...wheter it...

Someone else may have a better solution but this works:

this cursor based solution  finds columns that are of type VARCHAR, and then returns EVERYTHING that matches your input string

this would...

A while back in my shop i had to search all columns of type int.

In my case, many of the columns where actually foreign keys, but were not following the...

i'm a huge fan of constraints.... here's the things i typically look for:

in our shop, Primary keys have a naming convention: they all end in either "ID" or "TBLKEY"

You probably...

ALTER the database, and then start a transaction which tests if the feature you tried to change is changed. for example:

ALTER DATABASE PUBS SET AUTO_CLOSE OFF

--now test if the feature...

this is from a discussion post i had saved in the past: it used bcp to send to a dynamically named file based on the @id field; hope this helps.

DECLARE...

does this work for you? i just put the commadn into a string and caled the shell with the variable.

DECLARE

@TodayDate as varchar(40),

@TodayHour as varchar(40),

@TodayMinu  as varchar(40),

@NewFileName as varchar(100),

@cmdstr as varchar(128)

SELECT...

the move command really just copied the file with the given name, and then deletes the previous file. there is no need to move it with the same name, and...

you might not be aware, but all error messages from sql server exist in the sysmessages table in master; around 3831 on my machine;

select * from dbo.sysmessages

a more common...

The foreign keys hierarchy can prevent you from just deleting data in the tables;

the script below creates a list of all the tables in hierarchy order, and creates the delete...

the error you received is because child records exist which are not in the parent/referenced table;

run this query:

SELECT CLINICPHONE AS MISSINGCLINICPHONE,* FROM DBO.CENTER  WHERE CLINICPHONE IS NOT NULL AND CLINICPHONE...

I don't think the time to run DBCC CHECKDB is a function of the size of the database only, but rather a combination of something like

(number of tables) *...

On my dev box I had sql7 as the default instance , and SQl 2000 and SQL 2005 as named instances;

from the SQL standpoint I had no problem, and all...