i'm getting closer:

this query shows me my permissions, as well as the permissions i directly inherit from roles i've been assigned;

it does not handle any recursive role-within-a-role yet;

i'm thinking that's...

ok a follow up to my own question:

in SQL2005,

SELECT * FROM fn_my_permissions(NULL,'DATABASE') for my example above only shows connect permission, but on SQL2008 and above, it shows the "VIEW...

you'll need to show the exact code you are using.

with that, we can show you how to join against a calendar table to get a range of dates.

based on my...

you should have continued your question in the original thread.

this logic :

appends 4 preceeding zeros to the store number, then grabs teh right 4 characters...so store '1'...

not that i'm aware of as far as the log being more dedicated to SSMS.

did you manually look in the backup folder?

C:\Users\yourusername\Documents\SQL Server Management Studio\Backup Files\Solution1

and see if anything was...

Rob to help alleviate some of that headache in the future, grab the SSIS addin here:

http://www.ssmstoolspack.com/

one of the things it has is that it automatically keeps a history of every...

could it be based on an openrowset command??

--database name required

SELECT *

FROM OPENROWSET( 'SQLNCLI',

...

As far As i know, SQL Server doesn't have the specific granularity to restrict creation to only views;

giving someone ALTER permissions(like via GRANT ALTER ON schema or the role ddl_admin)...

I'mn out of practice, but it requires a correlated sub query, and what seems like a wierd format;

this is untested, but it's kind of like this, which looks weird (from...

based on your proposed format, [storenumber][ddmmy], you are assuming a store can only have one invoice a day? what if they want to have two?

3935 (6/27/2012)

---

Hey Guys,

How can i unique...

no. a commited transaction is...

also, to get the nth value, i'd add row number to the inner query :

declare @n int

SET @n = 4

SELECT sq.test

FROM (

SELECT row_number() over (order by name) As RW,

...

i had used the quickbooks driver from http://www.rssbus.com/ado/quickbooks/ so i could connect via a .NET application;

They had a decent amount of examples, and it was pretty easy to...

Jeff Moden (6/26/2012)

---

BWAA-HAAA!!!! I use xp_CmdShell to run PowerShell...

i believe your options are to use bcp, CLR or powershell

bcp + TSQL isgoing to require opening up xp_cmdShell.

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT object_name(object_id) As TbLName,name as ColName FROM SandBox.sys.columns...