Viewing 15 posts - 38,146 through 38,160 (of 39,478 total)
No way that I know of. I tried changing to a CHAR and the same results. Is there a reason you need this? Trailing spaces usually are not counted in...
February 4, 2002 at 10:03 am
What version of sql? If 7 or 2000, you can attach the databases and move them at the same time with the WITH MOVE option.
Steve Jones
February 4, 2002 at 9:57 am
Not sure if you can upgrade a v6.5 backup. Here's what I'd do. Get a copy of the v6.5 software, install it on a machine (separate) and restore it. Then...
February 4, 2002 at 9:55 am
Another vote for not using the Public role. also, I add the security scripting to my object scripts so they are always there.
Steve Jones
February 4, 2002 at 9:53 am
You can do the SET in a stored procedure. The issue will be that only one table in the database can have the identity set off at a time. So...
February 4, 2002 at 9:48 am
not doable. You could insert some value into a table and match the @@spid with the user on login.
Steve Jones
February 1, 2002 at 3:38 pm
Perfmon works ok, but it's not scriptable. Most software, like NetIQ, is too $$ for me. Testing a piece called MRTG, but not sure if it will work for me.
Steve...
February 1, 2002 at 3:18 pm
I don't have benchmarks, but I remember going to some sessions when ss2k was being released. They showed how the server makes decisions and doesn't even send the query to...
February 1, 2002 at 10:24 am
February 1, 2002 at 10:20 am
February 1, 2002 at 10:19 am
If you are going with the .NET platform, I'd look at ADO.NET. However, if not, ADO is very stable and mature and works great.
I do agree with Jon, but am...
February 1, 2002 at 10:18 am
Can you connect via client tools for SQL from a workstation? from the server? what about and ODBC connection from a workstation?
Steve Jones
February 1, 2002 at 10:14 am
February 1, 2002 at 10:11 am
You will not be able to have them on the domain at the same time. What I think you should do is detach and copy the databases, shut down the...
February 1, 2002 at 10:10 am
Shows you which newsletter you SHOULD be watching and which one you SHOULD NOT!
Steve Jones
January 31, 2002 at 3:34 pm
Viewing 15 posts - 38,146 through 38,160 (of 39,478 total)