I'll admit that I don't have all of the ASCII codes memorized. However, we've reached a point where rote memorization of such things is silly. If you need...

Thanks for the article.

Honestly though, I'm not sure how useful this will be in practice. To begin with, as mentioned, this is not going to be a good way...

Like the author, I use the 'usp_' prefix on all of my stored procs. The rest of the name is descriptive text. Personally, I like to be able...

One minor thought. You'll want to make sure that you put your paging file on a different set of spindles and, if possible, a different channel from your data....

<Parrot>

Rrrwwaaakk...Query Analyzer

</Parrot>

Unfortunatly, QA got bundled into Management Studio on 2005, so now, insted of being a simple, light weight, tool, it's a tool you have to dig out of a...

Perhaps I just missed it in the article, I admit i just skimmed it, but no one has mentioned using AFTER triggers for auditing data. e.g.:

CREATE TRIGGER AuditStuff ON...

select ident_current('Mytable') as CurrentID

Will get you the last identity value generated for a table.

If you want the next id use:

select (ident_current('MyTable') + IDENT_INCR('MyTable')) as NextID

Both will produce the...

Just to add a bit to what Shaun said. If you want to have full text searching of the documents, you can create a table with the document id...

You'll need to do a 2 step process. And you have a couple of options, you'll want to research which will work best for you.

<Option1>

Create a trigger on the...

Ok, I'm a rather weak on Access, but since we seem to just be throwing out ideas:

What is the text of the "Read_Function_Assessments_Make_Table_qry". At a guess, this is probably...

Do:

<code>

SET IDENTITY_INSERT MyTable ON

GO

INSERT INTO MyTable (IdCol, Col1, Col2) VALUES (0, 'value1', 'value2')

GO

SET IDENTITY_INSERT MyTable OFF

GO

</code>

You probably don't want to reseed the table completly, as this will end up with...

The first thing you will probably want to do is format the file as just data. For example, strip off the

'Test Type,Test Description
6,
'Version
2003.12.16
'Time Stamp
2006-01-04 16:05:49:406
'Access specifications
'Access specification name,default assignment
512B...

SQL 2k5 and VS.Net 2k5 Beta on the same machine can be a bit of a chore. During the development of SQL 2k5 and VS.Net 2k5 the versions of...

Just as another option, if you are using Office Pro, take a look at Infopath, which comes with Office. It's essentially a quick form making utility and it works...

Just to nitpick a bit (it was a nice article), but last I heard the systables are being depricated, as well, in favor of the system views. As such...