I am trying to set up a copy of our production site.

In order to do so, I wanted to do so by restoring user db's from backups and copying system...

Hi, still no luck.

I looked into the distibution db to determine the actual line that is causing the error: 

sync  -t"test_requests_floors"

        -d"c:\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\SQLDEV2_tbis_dev_requests\20050614203617\test_requests_floors_12.bcp"

         -hORDER( [request_id],[floor_id] ASC)

I even tried to run the...

I altered my scripts to reflect that option.

Now, I can run the snapshot, but when the distributor starts, I get the following error: "The process could not bulk copy into...

I am using the option to ignore delete given at that tab. I'm more concerned with generating a new snapshot if, for any reason, the entire process needs to be restarted.

In...

I am trying to implement the concept of only pushing inserts and updates but not deletes.

I have written a "pre snapshot" script.

Basically, execute a sp_rename for each table in the...

That would be great.

My email address is joel_raha@hotmail.com

Thanks,

jmr

Hi there,

Thanks for the response.

When thinking of how to store such data, but more importantly how to calculate any relavant information from what was stored, I realized that it wasn't...

I've been digging a bit further...

I think that the scheduling pattern used by outlook conforms to a standard called RFC2445 (iCalendar).

What I'm looking for is a set of tables/stored procedures...

I also have a custom application that needs to access a SQL Server database to retrieve calendar events.

To deal with recurring events, I would like to mimic the...

The original point of the view was to encapsulate business logic, and as a result, it includes some left joins and other properties that don't allow for an indexed view.

I...

My view doesn't actually contain any UNION clauses.

It has 20 tables.

All With JOINS OR LEFT JOINS. A few of the tables are large, most are small lookups. I feel that...

I have just experience the exact same problem and came up with the same solution. But I don't think that it will be a viable solution for us... just a...

I didn't mention it, but I had already run the following sp_configure options and restarted the sql server service:

sp_configure 'show advanced options', 1

RECONFIGURE

GO

sp_Configure 'awe enable', 1

RECONFIGURE

GO

sp_configure 'max server memory', 4096

RECONFIGURE

GO

I'm...

Here's a set based way that I think will work for all cases.

(Note that an integer can only be up to 10 digits.)

drop table tIntegerTester

create table tIntegerTester (id int,...

I'm definitely not certain, but I feel like this can't be done because the expressions that is used in the condition of the case statement would have to be included...