Viewing 15 posts - 38,416 through 38,430 (of 39,754 total)
February 4, 2002 at 10:44 am
Does the software connect via SQL Auth or Windows Auth? Can you run profiler and see if a connection is getting to the server?
Are you sure (just checking) you are...
February 4, 2002 at 10:38 am
Robert has my sugestion, but this might not do it all. Are teh connection passwords the same? Are all paths valid on the new server? Do the packages reference the...
February 4, 2002 at 10:31 am
Sorry for the delay, but let me weigh in here.
0% downtime isn't possible. No system in the history of the world runs with 0% downtime for any length of...
February 4, 2002 at 10:27 am
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
Viewing 15 posts - 38,416 through 38,430 (of 39,754 total)