Sorry can't let you off that easy. A point of view may be the issue but the table is not marked user it is in fact marked system just not...

But the point is the code as is does set permissions on that particular table. So the answer will affect system tables is correct whether ot not MS meant it...

See if this meets your needs.

select * from TEMP

order by

CASE WHEN ISNUMERIC(LEFT(PSNO,2)) = 1 THEN CAST(LEFT(PSNO,2) AS TINYINT) ELSE CAST(LEFT(PSNO,1) AS TINYINT) END, -- This line will handle up...

But only if you are imputing a string containing unicode characters or in some cases trying to insert into a n(dataype) field or variable.

From SQL BOL

Unicode Data

Traditional non-Unicode data...

Yes because of the following

If @start_date = '20040101'

and @end_date = '20040101'

Then any time value in appt.entered_datetime will be reduced to 0 for that day making it the value 'yyyymmdd' for...

When you say from a corrupted RAID 5 how bad are we talking (how many drives)? If more than one drive was damaged then you would be unable to get...

Even the updated documentation has that statement. However when I test using profiler and having copies of the table in other databases, they each have their own execution plan and...

Have you considered using a view for each table to link them all for reuse?

Just open the SP in master db in EM. Then you can look at the code it is using to understand it.

Also consider if the presenation will be handled in an application it may be simpler to put the logic in the application for the rollup than in sql.

Take a look at this thread. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=106984#bm110538

Look at sp_helpuser

Yes that should not be a security risk at all.

The first one with the xstatus of 18 and no srvid is the sa for this server. The other with a srvid looks like a remote server or linked server...

This should help as a starting point

set nocount on

if object_id('tempdb..#tbl_users') is not null

drop table #tbl_users

create table #tbl_Users (

 [name] [sysname] NOT NULL,

 [sid] [varbinary](85) NOT NULL,

 [dbname] [varchar](7000) NULL

)

INSERT #tbl_Users ([name], sid) select...