I don't think there is an easy way to do this that I know of. One option would be to set up some trace that would capture the events...

Have you considered using datepart(yy,month_end) somewhere in your query, and/or the group by clause possible

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy...

Will something like this work for you:

SELECT MAX(month_end),sum(num_units) from active_Units_Static where month_end = (select max(month_end) from active_Units_Static)

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a...

Might try something like this:

set nocount on

create table books(SubID int, PubID int, SubjectText varchar(30))

insert into books values(1486281, 594714, 'Domestic fiction.')

insert into books values(1486282, 594714, 'Psychological')

insert into books values(1486302, 594717,...

try:

delete from your_table

where col1 is null and col2 is null and col3 is null

Basically have a "is null" statement for every column in the table.

Gregory A. Larsen, DBA

Contributor...

You are exactly right about the the overhead related to a scaler function. My query does in fact use a scaler function and not a table function.

If your assumption...

Does the MSSQLSERVER service account have access to this network share? Can you see the directory when you execute "master.dbo.xp_cmdshell 'dir <UNC_NAME>"?

Note: replace <UNC_NAME with the appropriate UNC...

You must first create a backup device that points to your network share, and then backup your database to the backup device you created.

Gregory A. Larsen, DBA

Contributor to 'The Best...

I whole heartly agree with the client side solution when ever possible.

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp

Need SQL Server...

you will then need to code a sp_add_login and sp_adduser statements for each user. You should be able to easily build a text file T-SQL script from you raw...

The only way I know of doing this is to turn on AuditLevel property to allow succesful logins to be reported in the ERRORLOG file. You then need to...

If you know how many columns you want to create, you could do something like this to dynamically build the create table statement.

declare @colcnt int

declare @cmd varchar(1000)

declare @i int

-- this...

When bringing up the "Sub Menus" by hovering over the "Site Menu" items, I am able to see the text behind the the "Sub Menus". It is basically still readable,...

Opps forgot to add the link. You might want to try to use one of the links on this page to report the feature you found.

http://support.microsoft.com/default.aspx?scid=fh;en-us;feedback

Gregory A. Larsen,...

Microsoft will not say this is a bug, this is just a feature.

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp

Need SQL...