Have a look at this index. Most likely it will have a few variable length columns in it. There is a limit to index entry sizes, and it can be...

Another thing, you cannot use @t in the from clause if @t is not a table variable.

If you are passing only the name, you need to build up your query...

You can create a stored procedure in the master database, and name it sp_whatever

the sp_ will make it available in all of your databases, and the context will be the...

The "in" expression is converted into an OR, and there is no guarantee for the order in which the individual parts evaluate. However, if the order in which the items...

Neither the truncate nor the table drop will record individual row deletes.

Regards,

Andras

Yes you can, You need to use named instances.

Regards,

Andras

On SQL Server 2005 you can also use CTEs which will improve the performance:

WITH maxvals ( [Client ID], maxdate )

...

An expensive solution:

SELECT c2.*

FROM CLSERVICES c2

JOIN ( SELECT [Client ID]

...

Johannes Fourie (10/31/2007)

---

Sorry, I lied. sys.sqlmodules did not work. I tested with an admin login

When using a login who is only part of the public role it returns NULL

here is...

Johannes Fourie (10/31/2007)

---

Sorry, I lied. sys.sqlmodules did not work. I tested with an admin login

When using a login who is only part of the public role it returns NULL

here is...

Execute as expects a user in the database (items in the sys.users in the database). A simple example is:

create user blah without login

GO

create proc blah2 with execute as 'blah'...

Some answers to the many questions :

- Have a look at the VIEW DEFINITION permission

- on 2005 use sys.sql_modules instead of syscomments (this does not chop up texts over a...

Antares686 (10/31/2007)

---

Just be aware the table must have data in it to produce an...

You may also want to look at the SQL_VARIANT_PROPERTY. Not the nicest solution :), but:

select SQL_VARIANT_PROPERTY ( cast (1 as int) , 'BaseType ' )

gives you back int 🙂

Regards,

...

somefunction is typed, so at the moment you specify a parameter, the parameter is cast to the type the function accepts.

Are you trying to get the data type of a...