I'm currently supporting 2000 and 2005. We're working on getting rid of the 2000, but there are no current plans for 2008. None of the new features are...

Varchar(max), definitely. Unless you need non-Latin characters, then NVarchar(max). (That's for things like Chinese characters, Greek letters, etc.)

Run:select * from fn_trace_getinfo(0)

That'll tell you whether the trace is running or not (row 5 = 1 means it's running, 0 means it's not), and the file location.

Run:select * from...

RBarryYoung (3/9/2009)

---

The solution that I usually implement when I have a customer or situation that demands this ability (which is to emulate transportable-tablespaces from Oracle) is to actually put the...

Another way to sort of achieve this would be to leave them in the database, but put all the stuff you want separate from them into a filegroup other than...

SQL 2005 keeps a default trace running, unless you've turned it off. That should have the data in that you're looking for.

That is too funny! Nearly...

It's a common thing. It's because, with the hard-coded dates, the execution plan can take into account statistics, etc., that exist on that column. With variable dates, it...

After you remove the "(0)", does the second set of numbers always get parens around it? If so, then Steve's suggestion of using charindex/patindex to find the spaces around...

I think, if you downgrade the compatibility level of the database from 2008 to 2005 (100 to 90), detach the database from the 2008 server, copy the file over, and...

It looks like one of the connections has a 30-second timeout enforced on it, while the other doesn't. Per the screen shot, the one that worked took over a...

Depends on what you mean by "secure". Do they need to be encrypted? Does their transmission over the network need to be? Is the network you are...

Looks to me like you're just concatenating strings. You should be able to convert the values for ltv from numbers to strings and then concatenate them together. If...

Stored procedures and other code objects are, to my knowledge, always in the Primary filegroup.

Shouldn't you have a separate dev and test database (preferably one for each of those) where...

Try something like this:

declare @Phone varchar(100);

select @Phone = '+44 (0) 1908 123 456';

select stuff(stuff(replace(@Phone, '(0) ', ''), 5, 0, '('), 10, 0, ')');