Viewing 15 posts - 3,166 through 3,180 (of 3,232 total)
I agree with RGR'us. It sounds like you would be better served using one column to make this work. Otherwise, you would have to program this into the table triggers. ...
November 23, 2005 at 12:43 pm
No maintenance plan?? Does that mean that there has not been a backup of you DB in 18 months...Ouch! I agree with Vladan. The most common cause of EM hanging...
November 23, 2005 at 12:38 pm
You should not have to re-build your non-clustered indexes manually upon rebuilding your clustered indexes. If you issue a DROP index statement on a clustered index, SQL Server will automatically...
November 18, 2005 at 12:44 pm
If your select statement cannot find a match, then SQL Server will not execute the line following the IF Exists statement. You may want to place a BEGIN after your...
November 18, 2005 at 9:49 am
Ah, a fellow Progress/SQL Server guy....I thought I was the only one! At my last job, I was a DBA for Progress, SQL Server, and Oracle. I have not had...
November 18, 2005 at 9:15 am
Leave your stored procedure as-is. Change your application to first determine if the user is a customer or a worker. If it is a customer, leave your logic alone and...
November 18, 2005 at 8:43 am
It is difficult to fully analyze these queries without knowing which indexes you already have on your tables. One thing I would recommend doing is taking these queries, placing them...
November 18, 2005 at 8:34 am
Enterprise Manager is not the best place to make this type of change. You've proved this by capturing the actions that EM performs on your table simply by changing the...
November 18, 2005 at 8:29 am
If it is a VB6 exe, it doesn't matter if you have VB or .net loaded on your workstation. Everything the application needs to run should be included in the exe...
November 17, 2005 at 2:25 pm
It could be an issue associated with the user rights of your SQL Server account. See MS KB:
http://support.microsoft.com/default.aspx?scid=kb;en-us;840219
November 17, 2005 at 1:56 pm
I like fhanlon's idea of scripting osql commands into .bat files. This not only makes it easy for your operators, it allows you to control the process. Using a .bat...
November 17, 2005 at 11:33 am
Can you post your whole Stored Procedure?
November 17, 2005 at 9:48 am
You may want to try to look through sp_who and sp_who2. I think there is plenty of logic built into those guys that you could strip out and use to...
November 17, 2005 at 8:02 am
I don't know if named pipes uses different ports, but an easy way to determine this would be to have someone watch your firewall as connection attempts are made. This...
November 16, 2005 at 4:45 pm
The only method I know of that would allow you to do this and have it readily available to view would be to run a constant SQL Profiler trace that...
November 16, 2005 at 3:56 pm
Viewing 15 posts - 3,166 through 3,180 (of 3,232 total)