if you created a table that captures login info, then i think you need to GRANT INSERT ON [dbo].[rvvlogindata] TO PUBLIC so that any login would not fail inside...

you could simply sum the two together as a third column, i'd think:

SELECTComputerName AS 'Computer Name',

SUM(BlackWhiteTotalCount) AS 'Total B&W Pages',

SUM(FullColorTotalCount) AS 'Total Color Pages',

...

as usual, it depends on what you are looking for: object level permissions? ie does user mydomain\lowell have SELECT permissions on HR.dbo.Payroll?

did you find any script that was close to...

i wouldn't do this; the date format is valid, and since it goes into a date typed field, how does that adversely affect you?

what if an application passed...

there's a neat trick with FOR XML you can use:

declare @ttest table

(nItemintegernot null,

ctextvarchar(32)not null)

insert @ttest values (1, 'Row 1 text')

insert @ttest values (1, 'Row 2 text')

insert @ttest values (1, 'Row...

it seems to me that you might be able to replace the trigger with default values.

the WHERE criteria is huge in your example, and ALL must be zero to...

just stick the results in a temp table, where that table has the aliases already like this:

IF OBJECT_ID('tempdb.[dbo].[#tmp]') IS NOT NULL

DROP TABLE [dbo].[#tmp]

GO

CREATE TABLE [dbo].[#tmp] (

[GAMECODE] ...

run SELECT * FROM sys.traces.

you'll probably see two traces there; trace_id = 1 would be the default, and trace_id=2 would be your trace. look at the path column and confirm...

allaspects (4/7/2014)

---

Thanks! Unfortunately, I have tried those methods without any success. I am bound and determined to find a solution to this.

I will post one if I find one...

take a look at this thread, which in turn can point to other threads.

there are three different methods , by three different authors, that can search all tables and columns...

the specific error is going to be important for anyone to help further. if you can provide more details, we can offer some suggestions.

did you send a test email from...

MyDoggieJessie (4/4/2014)

---

If you don't mind using SSIS - You can also use the transfer jobs, transfer logins, transfer SQL objects, and transfer master stored procedures tasks in SSIS to keep...

this is basically the same solution as Gails in a different format; it's just a CROSS JOINED CTE to get the variable instead of a direct sub select.

CREATE VIEW myVIEW

AS

WITH...

since this is a one off, i would generate the statements, and copy/paste/run like this:

select

'ALTER TABLE '

+ quotename(object_name(object_id))

+ ' DROP COLUMN '

+ quotename(name)

from...

most users cannot run this unless you grant it explicitly either: (GRANT VIEW SERVER STATE TO [myDomain\developers]

)

SELECT client_net_address

FROM sys.dm_exec_connections

WHERE session_id = @@SPID

is [Developers] a role, or a placehoder for your...