besides 'N/A' it...

yes you are correct.

a sysadmin login can do everything.

a login with sysadmin priviledges performs work at a database level is performed in the context of the user dbo , which...

you'll need to cast or convert; you cannot compare strings like that; you run into trouble with greater than and between and stuff not behaving the way the value of...

vikramp 2790 (9/26/2011)

---

my procedure runs successfully except for first insert query does not insert rows into the table but auto increments id. but Other querys execute successfully. I...

InfiniteError (9/26/2011)

---

thanks guys for all the answers.

Sorry if my example is not that clear. My example assume that all are the same (same number of records, indexes, where clause). Honeslty...

InfiniteError (9/26/2011)

---

hey guys, need help on this one. I have a .net application, On sql side,Is it much faster to execute sp rather that inline statement? meaning from .net i...

dave i think it is C:\WINDOWS\system32\msorcl32.dll or C:\Program Files\Common Files\System\Ole DB\msdaora.dll as part of any MDAC that got installed (uusally already there);

my first recommendatino would be to change that to a larger Initial Size, which depends a lot on how big it is rig now. if it's 2Gig in size right...

Phillippe can we review some basic setups first?

What is the default size of tempdb? at startup, by default, it's a piddling 8 meg, and would grow by 1 meg at...

in the msdb database, you'll need to add the user, adn then make him a member of the [DatabaseMailUserRole] role.

USE [msdb]

GO

CREATE USER [user1] for login [user1]

EXEC sp_addrolemember 'DatabaseMailUserRole','user1'

RETURNS nvarchar

unless you explicitly state a size, the default is 1;

it's only when you are using cast or convert that the unstated size is 30

it's pretty common to assume ...

i think the issue is contextinfo is varbinary(128); you have to convert to nvarchar, and then to biginto to get the value you want.

exec

sp_help 'master.dbo.sysprocesses'

DECLARE @var VARBINARY(128)

SET @var...

Seth when i change the database owner, i seem to see exactly what id'd expect...two more databases

using my same code from above:

DENY VIEW ANY DATABASE TO DBVIEWERTESTING

USE SandBox

GO

exec sp_changedbowner DbViewerTesting

USE...

don't you have to stop and start the service to change the config values into run values?

i suspect the 3=changes pending as an undocumented status.

the command you are looking for is this snippet to hide databases the end user doesn't have access to:

DENY VIEW ANY DATABASE TO [SomeUserOrRole]

here's some testable code to prove...