Please join Microsoft experts in an online chat: SQL Server SP4 chat, sponsored by SSWUG.ORG Join members of the SQL Server development team as we discuss...
130
buddy_sona2004
Feb 9, 2005 10:59 am
Hi Friends!!! A leading global provider of Information Technology services in Bangalore, specializing in the design and deployment of leading-edge information...
131
Kris Sellers
msflinxusa
Feb 9, 2005 12:53 pm
That is what TampaSQLJobs forum is for. This is a technical discussion site. Thank you...
132
tpasql04
Feb 10, 2005 12:28 pm
By any chance do we have any advance guru in OLAP in the audience?. I ran into a problem with Reporting Services and OLAP, and have a question. I have a cube...
133
nicoleisc2
Feb 11, 2005 2:46 pm
If anyone has done a feasibility study in the past that can give me some pointers I would appreciate it. Any information that you may have on the subject would...
134
Garry McGibbon
swamprider5
Feb 19, 2005 2:14 am
At Tuesday's meeting, I had asked the group if they had seen this error message in the sql log, which has affected our Deli software, and seems to have...
135
Kris Sellers
msflinxusa
Mar 13, 2005 7:49 pm
I am moving a live server over, so this is a "Do it in 2 hours or less" type thing If I create the Security on the new server, then detach, copy and attach the...
136
Jeff Garbus
jeff_garbus
Mar 13, 2005 8:10 pm
Are you using sql server or nt security? Is it on the same domain? ... regards, Jeff Garbus www.soaringeagle.biz 813 949 7016 (o) 813 354 4681 (f)...
137
vennela_tech
Mar 14, 2005 7:17 am
Hi, Vennela Technologies is a Global Oracle Technologies and Oracle Applications services Provider with a good customer base in Middle East and Europe Vennela...
138
Kris Sellers
msflinxusa
Mar 14, 2005 1:02 pm
Mixed. Yes, it will be on the same domain ... up ... I...
139
Chris Leonard
nine_alpha_b...
Mar 14, 2005 10:29 pm
Kris, If you script the logins from the original server and put them onto the new server, and do the detach / attach thing, you will be fine. There is a ...
140
Jeff Duncan
duncanja_11
Mar 14, 2005 10:36 pm
The DTS job to copy logins does not copy the password. It will copy the logins and permissions but sets the password to blank. I am attaching the script to...
141
Bill Nye
billnye101
Mar 15, 2005 12:48 am
I'm assuming by "create the Security", you mean setting up the Server logins/roles under the Security tab. To do this I would script this out from the existing...
142
Jeff Duncan
duncanja_11
Mar 15, 2005 4:29 am
If you are moving over SQL and are replacing a box this is easy and you can actually do it copying over all the databases including system db's. If you need...
143
vennela_tech
Mar 15, 2005 11:04 am
Hi, Vennela Technologies is a Global Oracle Technologies and Oracle Applications services Provider with a good customer base in Middle East and Europe Vennela...
144
Kris Sellers
msflinxusa
Mar 15, 2005 1:31 pm
Everyone: THANK YOU for your help. I you are at the meeting tonight, I will thank you in person. OK -- to answer the questions: This will be a replacement...
145
Jeff Duncan
duncanja_11
Mar 15, 2005 3:54 pm
I have actually done it 20 times in the last 2 weeks. We just had a big move to a new IT center. I will be there tonight. Jeff Duncan Office 813-414-7008 ...
146
Bob
bobclark@...
Mar 15, 2005 4:14 pm
Excellent. I have a similar project to complete this week and would like to chat with you as well. Bob Clark ... From: Jeff Duncan To:...
147
Jeff Garbus
jeff_garbus
Mar 15, 2005 9:56 pm
Sorry, I'm in hartford this week... ... regards, Jeff Garbus www.soaringeagle.biz 813 949 7016 (o) 813 354 4681 (f)...
148
Chris Leonard
nine_alpha_b...
Mar 16, 2005 12:21 am
Kris, Unfortunately, I, ahem, live in Iowa. :o) So I won't be at the meeting tonight, I guess. I used to work at Tech Data, so I joined the group to keep...
149
Jeff Duncan
duncanja_11
Mar 16, 2005 7:06 pm
A lot of people asked me about this so here is a doc that I just threw together showing how to move all the user and system databases to another location on...
150
Jeff Duncan
duncanja_11
Mar 16, 2005 7:08 pm
Also.... If any of you use MSN Messenger my Messenger id is duncanja@.... Feel free to add me. I never check the hotmail email though. Only used for...
151
alihazzah
Mar 17, 2005 2:12 pm
Hi group, I enjoyed the two presentations given Tuesday 3-15; it was the first time I attended a meeting by this group, and found the speakers and audience...
152
tpasql04
Apr 14, 2005 8:35 am
In case somebody is interested, Quest software is offering a series of free webcasts on SQL: -Locking & Blocking – Diagnose and Resolve Problems Wednesday,...
153
Garry McGibbon
swamprider5
Apr 22, 2005 1:07 am
Here's the scenario: - sp_who (or master..sysprocesses) reports that a particular process that appears to be hung is blocking another process - admin executes...
154
Jeff Duncan
duncanja_11
Apr 22, 2005 1:28 am
It's a little tough with not seeing the problem. The first thing I would try after the kill is to also do the kill (spid) with statusonly to see what the...
155
Jeffrey R. Garbus
jeff_garbus
Apr 22, 2005 2:18 am
While you're at it, if it is a long-running transaction, it can take longer to roll back (the "kill" than it did to instigate the changes... May need only...
156
Mike Good
mikegooddba1928
Apr 22, 2005 2:42 am
can you post the full contents of master..sysprocesses for the unkillable spid? ... From: tampasql@yahoogroups.com [mailto:tampasql@yahoogroups.com]On Behalf...
157
Garry McGibbon
swamprider5
Apr 22, 2005 10:30 am
no transaction is rolling back. when this occurs it is evident from sysprocesses. ... From: "Jeffrey R. Garbus" <jeff@...> To:...
158
Garry McGibbon
swamprider5
Apr 22, 2005 10:42 am
I'd have to capture this on some future event. but there is nothing useful in this table other than what I have mentioned. But I don't think it matters how...
