Great Plains is an application which can use SQL Server as it's database.

Great Plains versions 5 through 6 offered a number of database options, including c-tree, pervasive, and MSSQL...

keep in mind that if someone is restoring the database, the restore point might not have the users you are adding back constantly; that's a probable thing to look for...

remember getdate returns the time portion of NOW: 2010-03-26 12:18:05.390

you want to start at midnite yesterday, not 12:18 of yesterday.

and another way:

--2010-03-25 00:00:00.0002010-03-25 23:59:59.997

select DATEADD(dd, DATEDIFF(dd,0,getdate()), -1),

...

all the levels can be found in this thread:http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx

Forum Newbie - 0

Grasshopper - 10

SSC Rookie - 25

Valued Member - 50

SSC Journeyman - 75

SSC-Enthusiastic - 100

SSC Veteran - 200

Old Hand -...

There's a couple levels of auditing to consider.

using a profiler/server side trace would capture the commands against the table, but not the data itself. That's idea for determining things like...

thanks Paul; awesome performance on that one; i added that to my toolbox; excellent solution.

irena did you use sp_create_trace to make a trace, or did you use profiler?

a trace created with sp_create_trace runs until it is explicitly stopped or, if it was created...

Trey already knows this...he identified it as deprecated...this is so other folks(like me) don't have to google it.

the DUMP word was deprecated in favor of BACKUP; you cannot even use...

you can do it allwithin the GUI;

note on my second screenshot by shrinking the log of my "Sandbox" database, I'm freeing up a huge amount of space by shrinking it.

the default trace would have that information if not too much time has past; the default trace captures DDL, but not DML changes.

easiest way is to point SSMS to the...

nice breakthrough Wayne; I couldn't get my mind around the multiple ranges;

performance on this solution sux, took my decent dev machine 1:09 to return the 151 rows, we might look...

shouldn't column 10 be at least one char wide?

10 SQLCHAR 0 0 ...

to build on sturner's idea, you could create a view which puts the data in the format sturner suggested, and do your queries per his suggestion:

Create View Sturners_Idea

AS

select empid, in1...

yeah the trigger should be doing a left outer join to test if the row exists, like this instead:

INSERT INTO TableName

SELECT...

i have this saved in my snippets; change the top 1000 if you need more; this version includes the dashes in the SSN

--results

RAND_STRING

675-45-3155

323-95-9117

024-41-4469

939-91-4719

966-36-0213

the code:

--neat , creates a random string that...