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))...

as i remember it, oracle doesn't auto cast strings to date nicely the way SQL Server does. you have to use the TO_DATE(' '2015-09-30 13:13:09.73688','YYYY-MM-DD HH:MI:SS') i think would work.

http://www.techonthenet.com/oracle/functions/to_date.php

jxj363 (9/29/2015)

---

I thought that each server had to have its own key that is unique to the machine. We have a dev server with reports, and now want to...

DECLARE @ObjectName sysname = 'UsedInView'

SELECT

SCHEMA_NAME(so.SCHEMA_ID) AS SchemaName,

so.name AS ObjectName,

so.type_desc,

sed.referenced_server_name,

...

basically, yes. you might be able to create a procedure featuring execute as owner,a nd grant an end user permissions to that, but thye cannot run dbcc themselves.

here's an older...

actually, the dll is uploaded into the database, and can be extracted to disk,...

my quick proof of concept looks like it would work:

i just grabbed an Ms template, saved it, and started combing through the raw text.