By default, an update to a unique column in a replicated table is converted into a delete/insert pair in the subscribing database. If you have FKs on this table in...

Here's a quick way to get the output into a temporary table:

create table #t1 (

bufferdist varchar(80) null,

numbuffs int null)

insert into #t1 exec ('dbcc memorystatus')

--drop table #t1

select * from #t1

HTH,

Steve...

I found a solution to this problem - I had to alter the linked server definition to allow more security contexts to connect (had to set up a user name...

I ran a trace when changing the default data file location in EM and saw the following query result:

xp_instance_regwrite N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData',REG_SZ,N'C:\MSSQL\Data\'

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

You can establish default folder locations for both data and log files through EM - select server properties and click on the "Database Properties" tab.

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver,...

I've found that applying a function such as "upper()" on an indexed column in the where clause causes the optimizer to disregard the index. If you're server is not case-sensitive...

Gregory, I think you mistyped the command - try

DBCC SQLPERF(logspace)

instead.

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

Try this:

select db_name()

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

I have a couple of processes with similar behavior. Don't know how good my solution is, but it works. I code the trigger to execute a sql server job that...

You can also use the ascii value of the character, as in char(39) for a single quote character.

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

Go look at your database server screen - I bet you'll see a messagebox indicating there's no disk in Drive A: and awaiting someone to press a key. I get...

Can you provide a few samples of the actual data coming in from the BBX system? I'm sure you can do some string manipulation work on the quasi-date field to...

Your select, setting @date equal to first_m_Date, is not part of the actual "select ... from" of the query. You really don't need to set up a variable to hold...

Wouldn't the ISNUMERIC() system function suffice? Like so ...

IF ISNUMERIC(varchar_field) <> 0

BEGIN

do your tasks for numerics

END

ELSE

...

I bet that what's actually coming to the subscriber in the event of a record update is a delete-insert pair of transactions instead of a true update. The MS Support...