yes it's fixed...my original posts had only single line that stretched a million characters....Steve's all over it apparently.

it sounds like if Field 2 is supposded to be a part of field 1, it should either be a calculated column instead, or have a check constraint.

create table #example(exampleId...

try this from my saved snippets::

it's a proc someone asked for so they coupd capture sp_who2 throughout the day:

CREATE PROCEDURE PR_CAPTURESP_WHO

AS

BEGIN

SET NOCOUNT ON

IF NOT EXISTS (SELECT...

i would simply create a view, rather than insert into a new table.

the view would always be correct, where the table would need to be updated every time table2 got...

thre's a difference between "log" files created by some application, and SQL's log files...i think dmc was thinking the log files you are talking about are SQL's.

if you have an...

if you declare a char(50), and put a single character in it, because of it's datatype it will add 49 spaces on the end.

that's the expected behavior.

Varchar(50), on the other...

omg Adi great minds think alike. paraphrased but verbatim answers

use a char1, and simply put a check constraint--

CREATE TABLE blah(

GENDER CHAR(1) NULL DEFAULT 'U' CHECK(GENDER IN('M','F','U') --U for undisclosed? some politically correct places require that nowadays

here's my suggestions:

1. update statistics:

2: can you show us the procedure? it might be the parameter sniffing issue(search here on SSC)

3: can you show us the execution plan? that shows...

Jeff it does still work; it depends on the commands you use; I've got an article coming out on a procedure i wrote that returns the DDL of any table;

your...

to get a procedure to run under the context of the database it is called from, doesn't it HAVE to be in the MASTER database and also at least start...

also from within SSMS:

Tools>>Options>>Text Editor

Expand "All Languages"

under the "Display" section, there is a semi-gray checkbox...uncheck and check to enforce line numbers for All languages and files.

Now line numbers appear on...

you could also use a logon trigger that checks the login against getdate() & some expiration date in a table, and use that logon trigger to prevent logging in.

both sqls in the union seem to be filtering on Application name, so If they ran alone, I would think they'd be fairly quick.

the union instead of union all could...

if you know the administrator password when you set up the machine, you can log in as that:

at the login screen which lists all the users, hit control-alt-delete twice...this will...