tempdb is recreated every time the server is stopped and started.

the only way to reclaim the space (as far as i know) is to stop and start the service again.

something...

JamesX (3/9/2012)

---

I would if i could, but the tables are built by a program that was written from the manufacturs of the mainframe, each night it rebuilds the tables and...

i believe this is only items that have a chached plan that was recently used; if the command is not in this, you'd have to add a trace to capture...

kewl! where can i find that? can you send it to me via email?

this one loks so interesting, but I'm not able to take the time to convert the data in the screenshots into tables myself.

can you post a few sample rows of...

set the value to 39167687

the next value inserted will be 39167688.

proof of concept:

CREATE TABLE MyTable(ID int identity(1,1) not null primary key,someval varchar(30))

insert into MyTable SELECT ('normal')

insert into MyTable SELECT ('normal...

one piece of it is a catch all query, right?

And @SyCampusID = Case @SyCampusID When 0 Then 0 Else SyCampus.SyCampusID End

to see them all, i'd use row_number:

select row_number() over (PARTITION BY name, description ORDER BY code, name, description) As RW,

code, name, description

FROM YOURTABLE

from that same query, the ones with...

stick with dynamic sql;

something like this seems to work for me:

declare

@isql varchar(max),

@dbname varchar(64)

SET @dbname = 'TargetDatabase'

declare c1 cursor for

SELECT modz.definition

FROM sys.sql_modules modz

LEFT OUTER JOIN sys.objects objz

...

to see all users, you need to grant view server state permissions.

grant VIEW SERVER STATE to TheRightRole;

also, you'd get an error if you try to use * and also schemabind a view:

CREATE VIEW v_YOURTABLE

WITH SCHEMABINDING

AS

SELECT * FROM YOURTABLE

Msg 1054, Level 15, State 6, Procedure...

yes.

if the view is not schema bound, if you created the view with select *...that gets compiled to a select featuring the actual columns at the time of creation.

you can...

Agreeing with Elliot here;

i've seen numerous posts here requesitng the same thing.

AFAIK the biniaries that are the core service and stuff must be installed on the %systemdrive%, with no...

conceptually, i understand now; it'd a STDEV of the 6 values, right?

if you can provide a set of commands for some sample data

CREATE TABLE ...

and also

INSERT INTO...

we could show...

the SQL server function STDEV takes a column name;

it sounds like you want the STDEV of 6 columns in a specific row, or a

all values ?

if it's the 6 columns...