to expound on Adi's point, the defered name resolution is for objectnames..table/proc function/etc,.

if a table exists, but a COLUMN you reference does not exist, then it won't compile...

so if your...

here's an example I hope helps you visualize it:

you want to try to give users only the rights they need.

use [SandBox]

--grant select/insert/update, but Not Delete to a specific table

CREATE ROLE...

i've got this saved in my snippets, but it would add only two decimal places, not three...does that matter to you?

results

@test-2 formatted

7265342 ...

Ranga it doesn't matter which account YOU logged in with.

when SQL server tries to access anything outside of the SQL instance(xp_cmdshell, files/folders/, network shares, anything outside of it's own databases)

it...

tan110 (10/23/2009)

---

Scripting help - Need a query to find filenames and filepaths under a certain directory.

I need the results to be something like this:

filepath ...

i don't think this should be checked...that means use https: or whatever the equivilent is...

change your screen resolution;

I've had that happen to me in visual studio, where the find and replace comes up as an undocked window, and gets tossed to a point that...

it's actually usually used for parsing up a Server.Database.Schema.Tablename object, but like you identified, works perfect for IP addresses as well; anything that is getting chopped up by periods; I've...

if there are exactly 3 decimals/4 parts in your string, you can use the built in function PARSENAME.

otherwise, it's the same idea, just more involved by using CHARINDEX and SUBSTRING

declare...

why not use a windows group that has admin rights? you give them a network login, set the password to expire in three days or whatever, and you are done;

they...

ok this was a kewl project for me;

to solve it, i used a function similar to CHARINDEX, but i used the AT() included below...it returns the Nth occurrance of a...

frank what we are looking for is the specific rule so we can help you;

for example is this statment true:

in the data sample like this:

"from right to left,one subdirectory exists...

i think this is what you are looking for; you need to use a CASE to get your "conditional" count that you were trying to do in the internal WHERE...

the command you pasted is just one piece (actually the last step) of enabling FILESTREAM on 2008:

it's got a syntax error as well; it should be thisL

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

http://msdn.microsoft.com/en-us/library/cc645923.aspx

Before...

not true; SQL 2008 Express supports filestream:

Microsoft (10/20/2009)

---

http://msdn.microsoft.com/en-us/library/cc949109.aspx

SQL Server Express

SQL Server Express supports FILESTREAM. The 4-GB database size limit does not include the FILESTREAM data container.

However, if FILESTREAM data is...