I tripped over that issue as well;

below I pasted a function i made for encoding "illegal" characters, it might help you out to clean up the data, or get the...

ok, I'm assuming that by consecutive, you mean that the PK is an identity field, and that if you self join the table on itself by way of PK =...

behind the scenes, the GUI is creating a new table, then dropping the constraints on the old table,

dropping the table, renaming the new table to the proper name, and...

connections are not really handled by SQL server, but usernames/passwords/spids, once a conenction has been made is auditable.

If you need to know who is connecting by IP, you should capture...

yeah that binary AND-ING of a value isn't obvious;

basically, a binary array of zeros and ones, representing like 2^16 or something is used in status to keep track of on...

I have this laying around from a post i replied to previously: it does all the databases in one shot on a server, instead of calling sp_dboption repeatedly:

select name as...

I agree, it's a poor idea. It sounds more like the DBA gets confused with seeing thousands of tables, and to make it more "bitesize" he wants to move...

the Command SET XACT_ABORT ON makes error handling superfoulous.

This command rolls back the transaction, AND DISCONTINUES FURTHER PROCESSING, if any error is encountered....

so if any error is encountere,d it would...

I do something kind of similar using the SPACE function to reserve a certain amount of space in a string; I used a default of 20 in this example, but...

much easier to do that from an application.

from sql server 2000, it's difficult to do in TSQL because you must use an object with sp_oacreate to get the text of...

thekingironfist (2/11/2008)

---

Hi folks, every time a date is entered into SQL Server 2000 as a 12:00:00 AM time, it becomes automatically truncated to only the date.

Example:

I type:

2/11/2008 12:00:00...

the freespace will just get larger as you cleanup your data, until you shrink the database...when you shrink the database, only then will the actual amount used get smaller. until...

Tim ffitch (2/11/2008)

---

Hi.

We have a Select statement in a stored procedure that uses the IN Operator.

When we use the following style it works:

WHERE IN ('Value1', 'Value2', 'Value3')

However we have a...

there's so many variables, it's hard to give a good answer without reviewing the code;

In general, here's something to look at:

A lot of times, dynamic sql is used in order...

if the database is version 80, the script is not valid for the part i highlighted below...that part is 2005 /90 database only:

CREATE TABLE [dbo].[Primes](

[Prime] [int] NOT NULL,

CONSTRAINT [PK_Prime] PRIMARY...