As far as i know, a SYNONYM must point to an object, that is, something that exists in sys.objects. that's typically, a table/view/procedure/function, but could technically be anything that exists...

i think you can streamline it a bit by using a neat technique using SUM(CASE..)

SELECT

SUM(CASE WHEN SALARY BETWEEN 10000 AND 20000 THEN 1 ELSE 0 END) As Range1,

SUM(CASE...

it might not be obvious;

for example, if it's a windows account, ie mydomain\lowell has too much access, it's probably because i'm in a windows group

that has direct or implied access

SQL...

it sounds like the user in question has a LOGIN which was granted sysadmin privileges.

i don't have QA available for SQL2000 anymore, but you can go to the properties of...

i'm not clear ont he question, i may be reading it too fast.

if the question is "how do I execute a stored procedure via OPENQUERY,a dn capture the results, the...

DDL only, or DDL and also the data?

if it's just the DDL , i'd use the SSMS scripting wizard.

IN SSMS Object Explorer,

Right Click on a specific database.

Click Tasks>> Generate...

adinica (4/5/2013)

---

Thank you. It was exactly what i was trying right now. I have a question, how do I refer to the server I am on in the openquery? Is...

if you create a permanent or temp table that has the shape of the data, you can insert into it;

a rough example, but it works on my side, assuming the...

i think the OP should probably just convert the time to seconds, and use DATEADD whenever he needs to fiddle with the values.

at least , as an integer, you could...

doh! now i see it!

i just peeked at my other instances, and the same code is in 2008R2 and...

i'm still confused and looking in the wrong place, clearly.

i did sp_helptext 'sys.fulltext_catalogs', and it's a system view on my 2008 instance, i'm not seeing the same code you posted;

can...

i would disagree.

if you look at the definition for 'sys.fulltext_catalogs' via sp_help, the datatype is clearly int for the column fulltext_catalog_id you are selecting

/*

Column_name ...

you can explicitly call CHECKPOINT yourself, would that help?

--UPDATE MyTABLE ....

--INSERT INTO SomeTable

CHECKPOINT

--UPDATE MyTABLE2 ....

--INSERT INTO SomeTable2

CHECKPOINT

balasach82 (4/5/2013)

---

Error: 18456, Severity: 14, State: 5.

The login ZZZZ exists and it is linked to the user in the db. Still we get the error

>>> Login failed for user...

here's a very similar version when compared to Jasons;

if a user matches it's login SID, it fine and nothing needs to be changed.

If the SID doesn't match , it builds...