dynamic sql to create the database? that won't fix any warnign where you have a USE [NewDB] that doesn't exist at parse time, i think:

if NOT EXISTS(SELECT * FROM...

I know you explicitly said same server, but that's too weird.

so theres no chance you are in a multi server environment, and the window you look at is test/development, but...

my first google for "linked server analysis servers" looked good to me,: they both showed examples of crating the linked server and the open query command as well.

select * from...

this is what they call a "ragged right" file format, and bcp and bulk insert cannot handle that;

see this post for an example of how to do it, but the...

Jeff Moden (1/8/2015)

---

Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers alike is "How do you get...

jrodriguez 62807 (1/7/2015)

---

I am somewhat new and for that please forgive me but I need to create this script and it is driving me crazy that I can't figure it...

it's a question to make you actually talk about details and solving difficult processes, so they can get some insight into how you solve problems.

it's not a real, qualitative question...

i bleieve you recently modified this location in SSMS, which decides whether something is scripted with a if not exists selection:

it may have been modified as a patch or something,...

15 filewatchers, That's what i was originally thought i might have to do, and then i thought a script task that uses some code, that institutes a filewatcher would be...

isn't it true that only procedures that have been called would have a cache in place?

so if it's not in cache, it's either been aged out, or never called,...

i think it's application name and hostname(workstationID) that can be spoofed. username , not a login, bu if your priviledges were high enough you can start using execute as...

if you include System.IO, you can use the FileInfo object:

--this is vb.Net code

Dim MyFileInfo...

a quick follow up:

when you run the command above , you get results like this:

you cna see any of the blue links or the plan itself becomes clickable.....

one of...

yes you can..

there is some really nice optional features for the procedure.

try running it with these flags:

EXEC sp_whoisactive @get_outer_command = 1,@get_plans=1,@get_full_inner_text=1

here's the list of parameters(sp_help sp_whoisactive)

yep a rough example: set parseonly makes sure it's syntactically correct, but doesn't check for object existance:

DECLARE @code varchar(max) = 'SELECT * FROM syys.tables';

EXEC ('SET NOCOUNT ON;SET PARSEONLY ON;'+ @code)

EXEC(@code)--Error...