Viewing 15 posts - 38,386 through 38,400 (of 39,720 total)
I like Brian's suggestion.Just be sure that you are updating the table correctly on login. If a connection fails and another logs in, it could recieve the same SPID as...
February 4, 2002 at 10:15 am
Or you can create a real table and use the SPID as a column. When you start the sproc, delete all rows with your @@SPID. Then insert your data, including...
February 4, 2002 at 10:11 am
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
Viewing 15 posts - 38,386 through 38,400 (of 39,720 total)