we had a similar issue in our shop...we needed to merge two databases together, with each table having different data, but possibly the same identity() values.

we had to build...

Jeff was just fiddling with it...add a reply, emails get sent, delete teh reply, the link in the email can't find the posted reply. expected behavior.

WHY he was testing, we...

Jeff Moden (10/1/2007)

---

Heh... those are fun but I like the real-life questions that teach why or why not to do something... for example...

1. How many internal rows will be...

this would give you the sample structure to test each column in a single pass...is that what you wanted, or did you want where an entire row was null?

select SUM(CASE...

from what i remember Clipper was just a Visual Foxpro, right? so it's simply a .DBF file you connect to using dts and import the whole thing:

Enterprise Manager, Select database...Right...

you can restrict access to executables and such via NT permissions and Active directory.

Once connected, unless you restricted his access to some objects, he's pretty much got access right?

if he...

creating and deleting replys, it looks like from my forum emails.

Serg is right; what is your trigger doing? Is it calling a stored procedure or something ?Is it using spOACreate/xp_cmdshell? trying to email something? does it declare a variable? does...

not sure which programming language you are using, but having a recordset/datatable with Userid, RoleId and RoleName might be more flexible;there might be other items you'd want handy in the...

I would return a recordset/datatable of multiple rows instead, if it were me;

something like

]SELECT UserRoles.UserId,UserRoles.RoleId,UserRoles.RoleName from UserRoles where UserRoles.UserID In (SELECT UserId from Users where UserId=12)

Or

SELECT UserRoles.UserId,UserRoles.RoleId,UserRoles.RoleName from...

doh so simple; thanks noeld

still looking at the problem, but here's the DDL I created for testing:

SET DATEFORMAT dmy

DECLARE @Sample Table(Account varchar(30), Product varchar(30), StartDate datetime,EndDate datetime,Bonus int)

INSERT INTO @Sample

SELECT '20943','A','26/01/2005',NULL,10 UNION

...

select * from master.dbo.sysmessages where error = 16945

select * from master.dbo.sysmessages where error = 16937

select * from master.dbo.sysmessages where error = 16954

error = 16945: The cursor was not declared.

error =...

because you don't want to overwrite the database, it's much more difficult. foreign keys for tables may bite you in the tailfeathers.

this is what I would do:

restore a copy of...

take a look at this thread:

http://www.sqlservercentral.com/Forums/Topic385732-9-1.aspx

it has solutions for the defined size you are looking for, as well as MarcusB's solution for the largest row in the table, and finally...