if they need access up to the last second, i'd do this, but it takes twice as much disk space:

restore the production copy to the ReportServer as a different name....

rajemessage 14195 (10/10/2015)

---

hi,

some times i need to take db in single user mode , which can be done

using following

use master

go

alter database db_name set single_user with...

SQLPain (10/7/2015)

---

John,

I have added linked Server S with report server. Can you please give an example of what would be considered as a fully qualified code.

Also when I write the...

since it sounds like you don't wantto remove permissions, but to prevent it from running with all default parameters?

can you modify the stored proc itself?

that's the low hanging fruit,...

is the destination a network...

then you are out of disk space on the drive? you might need to...

you'll want to uninstall, and then reinstall, two separate steps, sorry.

there's no way to convert a named instance to a default, nor is there a way to rename it(ie from...

agreed. they added code that insta-deletes anything Celko posts(thank you for that!), so they can reuse that same code, and just add something that detects the new user spamming multiple...

toniothomas (10/2/2015)

---

Check if the query posted at this link works. Seems to get me what I want with respect to an index creation date

http://www.sqlpanda.com/2013/10/how-to-check-index-creation-date.html

SELECT object_name(i.object_id) as TableName, i.object_id, i.name, i.type_desc,o.create_date,o.type,i.is_disabled

FROM...

RTaylor2208 (10/2/2015)

---

I meant to add, that realistically if you want to pass the exam and more importantly know the functionality inside out you have to be prepared to give...

i believe the command syntax like this will work as well: i use it for creating tables remotely:

EXEC ('DROP DATABASE [SandBox]') AT MyLinkedServer

how do you test in SSMS with multi value parameters, then?

it's going to come down to your implementation...can you paste the actual code?

the actual error message? "does not work" is...

if that's too slow, the next step is a CLR Common Language runtime splitter. that's the fastest i've encountered.

I've personally grabbed this specific code from SimpleTalk[/url] and used it to...

mw112009 (10/1/2015)

---

Ok thx

Can you help me with this then ?

I like to write a query where I pass a name of a table and column and then it will simply...

where

(@VendorNumber is null or (hh.vndno = @VendorNumber))

and hh.chkdts = @CheckRunDate

and dd.DPSTF = 'N'

and hd.FILET = 'H'

and cd.EDI835Exclude = 0

and (@CompanyCode IS NULL OR ( cd.CMPCD = @CompanyCode))...