Here are a few examples that might help you out:

set nocount on

create table skill(candidateid int, skill varchar(10))

insert into skill values(1, 'xml')

insert into skill values(1, 'oracle')

insert into skill values(1, 'j2ee')

insert into...

Here are a few different examples that might help you out.

set nocount on

create table skill(candidateid int, skill varchar(10))

insert into skill values(1, 'xml')

insert into skill values(1, 'oracle')

insert into skill values(1, 'j2ee')

insert...

Yes.

In SQL 7.0, you can use the "exec master.dbo.xp_trace_enumqueuehandles " to determine if any profiler traces are running. If no records are returned, no traces are running...

There are a number of ways to return data from an SP, are you trying to return a record set (a number of rows), or a single value? Does...

I have an example on my site that might work for you. Here is the link:

http://www.geocities.com/sqlserverexamples#dup2

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at...

If you have exe's that issues SQL commands, profiler still might be a tool someone could use to determine a sequence of SQL commands used to perform a task.

Gregory...

I've been thinking of switching to a Windows network share to see if problem goes away, but have yet to try.

Gregory Larsen, DBA

If you looking for SQL Server Examples check...

This has been happening to me as well. I save most of my stuff to a Novell file system, and I am wondering if this has something to do with...

I would create a SQL Server Agent job that runs nightly and deleted records that are older than a year

Gregory Larsen, DBA

If you looking for SQL Server Examples check out...

No.

You could DTS the tables to flat files, where the flat files will be your back.

Or you could DTS the tables to another database, and the other database...

If shorter is better then try this:

declare @eftv_dt decimal(20,6)

set @eftv_dt= 19991217120902.000000

select cast(left(stuff(stuff(stuff(@eftv_dt,9,0,' '),12,0,':'),15,0,':'),17) as datetime)

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Yes you can. Check out the Q article. It has a script that builds a script to transfer users from one server to another.

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

Gregory Larsen, DBA

If you looking...

I think I would just have one big partition, although I suppose if you want to seperate the operating system and sql server you could have two.

Gregory Larsen, DBA

If you...

I agree with nmoore, although with only 4 disk, and 1 for hot swap, that only gives you 3 disks to work with. I really don't think you have...

Thank you for the tips. Turns out the "DefaultData" and "DefaultLog" entries only exist after you have initial set the default directories to something. If you have not set...