i thought it was pretty straight forward from there;

you would simply modify my example with a WHERE statement...

WHERE filz.[name]='XXX_2012'

if you need a fulls cript, i'm pretty sure if you search...

newbieuser (7/10/2013)

---

Thanks. I'm confused with this one.. I set the maximum server memory(in MB): 2147483647 on the database server. But i the task manager sqlservr.exe is using 3349316K memory. So...

i'll throw my two cents in;

I use a combination of saved scripts in a specific folder(lazily using C:\Users\<username>\Documents\SQL Server Management Studio\Projects, and that folder has subfolders and hundreds, probably thousands...

most likely permissions, because the startup account of SQL server doesn't have access to the network share.

When you touch anything outside of a database, SQL server does not use...

well, i've got this saved in my snippets to find tables by filegroup:

SELECT

objz.[name] As TableName,

objz.[type],

idxz.[name] As IndexName,

...

lloks like the string is constructed slightly wrong: thank goodness for the print statements!

i think the cod eneeds to be changed...

because your obiwan user is going to be creating logins and also executing AS., it needs to be a sysadmin(for CREATE LOGIN) and db owner in the database (for...

note: 7 year old thread.

Brandie you are spot on about the too literal thing, and i knew it when i heard the requirement; I thank you for your time in adding to my question...

instead of

EXEC sp_executesql @sql

use

EXEC(@sql)

which has no limits on the query size, since it's not parameterized. ou are not passing parameters via sp+executesql, so you'd be good to...

vinod.venugopal 71189 (7/9/2013)

---

I thought SQL Server 2005 has to be on SP4 or above before we plan to migrate/restore it to SQL 2012.

Thanks for clarifying my doubt. I will...

ok, i've seen that kind of thing, but that's basically a wireless monitor cable right? only one person can use the screen?

I don't think that's quite what i'm after, but...

you can get the IP address for connections, if that helps;

compare this to sp_who2, and see if it helps you any:

select

conns.client_net_address,

conns.auth_scheme,

sess.* from sys.dm_exec_sessions sess

LEFT OUTER JOIN sys.dm_exec_connections conns on...

ok if anybody has some answers on my off the wall post here, i'd appreciate it: this is more of a "heard of an app that does this"? question:

"Throw it...

it's a property...