you'll want to give VIEW DEFINITION to them;

--at the database / schema level

Grant View Definition ON SCHEMA::[dbo] To [AlmostOwners]

--at the database level

Grant View Definition To [AlmostOwners]

--at the Login level in...

i think you can find it by getting a datediff in hours (or minutes, as some time zones are different by half hours)

and then add that diff to your utc...

there is a project on codeplex i briefcased that allows you to add a CDC equivilent to plain old SQL 2005/2008, stadnard editions , so you don't need Enterprise...

you can use the LEN() or DATALENGTH() functions:

SELECT max(DATALENGTH(TheTextField)) As MaxDataLength FROM

TheTable

by max character you mean the highest ASCII value? like 'A' = 65 and 'a' =97?

so the highest "char" in 'bananas' is 's' with an...

tough to diagnose without the whole, testable code...

there's a table variable that's missing, and the declaration and assignment of the @Counter is missing...it does get assigned the value of...

pretty interesting; for one specific collation, i ran this query and got a lot of interesting results...A=À with an accent, for exmaple. I'd seen this before, good to be aware...

I was thinking along the same lines...it might not be owned by dbo:

select

schema_name(schema_id) as SchemaName,

name...

the default database assigned to the login CORP\shilpa was dropped; change it to master adn try to log in again.

you can't.

once a person connects to SQL server, additional verifications are not possible from SSMS.

So if they have permissions to perform a a backup or a restore, you can't make...

how does a row number example perform?

SELECT

Server_Id,

Data_Timestamp

FROM

(SELECT

ROW_NUMBER() OVER (PARTITION BY Server_Id ORDER BY Data_Timestamp DESC) AS RW,

...

just a copy paste error...you left the column name attached to teh table name:

Insert into #FullDataGrid

Select '', createdtotal,'','',''

from #datecreated

INNER JOIN #DateCreated.CreatedDate

on #MasterDate.Date = #DateCreated.CreatedDate;

wow...changing that setting that i posted the screenshot of is SUCH a bad idea in SQL server.

testing that, i updated one row in a table, and saw i got...

to follow up on what Pablo said, here's a simple example:

CREATE TABLE WHATEVER(

WHATEVERID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

DESCRIP VARCHAR(30)

)

INSERT INTO WHATEVER(DESCRIP)

SELECT 'APPLES' UNION

SELECT 'ORANGES'...

even a filegroup backup might not be all you need; if all the tables are backup up in a file group, and then a change occurs to one of them,...