DBCC SHRINKFILE is granted to the roles sysadmin and db_owner

to remove permissions from a user, you'd most likely take away the db_owner role from them.

there is no other way...

it might be more clear if it looked like this...the zero is the first date in SQL:

select DATEADD(wk, DATEDIFF(wk,'19000101 00:00:00.000',getdate()), '19000101 00:00:00.000')

--is the same as

select DATEADD(wk, DATEDIFF(wk,0,getdate()), '19000101 00:00:00.000')

--is the...

Dan this is one of the coolest things to use once you get your head wrapped around it.

if you select DATEDIFF(wk,0,getdate())

this will return week '5763' , which is the #...

you can use the DATEADD and DATEDIFF function to determine the monday of the current week.

--Monday of the Current Week

select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)

so you want to avoid converting a datetime...

Steve i made an ITVF based on your example, but i added a bit more to it;

i was thinking if i allow periods in the data, i need to check...

you probably heard wrong, i think.

a SSRSreport is saved to a .rdl file(RDL=report definition language?), which is xml for the report's structure,design,location of all it's objects, etc.

that is what your...

calvo's example is exactly correct, i think; the EXEC() statement is stand alone, and does not affect the session/window it is a part of.

so to do what you want, you...

this will give you the results featuring row_number(); use the inner portion of the query to see the raw results, the outer query returns just the duplicate items:

productname,colorcode,categoryname,brandname,colorname

SELECT * FROM...

will you be providing any details? For any meaningful answer we need the CREATE TABLE definitions of both tables, and which "value" (column) triggers some change to be propigated to...

i think it's an html thing, if you put a space or an html non-breaking space, i think you'll fix it:

=" " & IIF(Fields!occ_period_id.Value = Parameters!spid.Value,"Red",IIF(Fields!show_date.Value = "Grand total" OR...

i think you can generate the ALTER TABLE ALTER COLUMN statements with this:

select

schema_name(objz.schema_id) as schemaname,

objz.name as tablename,

colz.name as columnname,

colz.max_length,

'ALTER...

well, the command line program osql can give you a list of all SQL servers that answer on the network, whether they are SQLExpress versions or not would require running...

ok rich; I'm putting a link to CLR Database Project and it's solution; after unzipping it and opening it in the BIDS version of VS2008, if you go to the...

that doesn't sound right...if you can do File>>New Project, is there a template for Database Project?

I know you can download the VS Database Template from MS, and there is instructions...

well, i've done the basic setup lots of differnet ways, from providing a database for the dba to attach, to providing a script for the dba to run, to doing...