Viewing 15 posts - 2,911 through 2,925 (of 7,429 total)
Have you isntalled any hot fixes. If so it may have revisioned a file backwards. Check your @@Version as well. I am running 2000 with SP3 and get no access...
May 28, 2003 at 5:45 am
We all agree that most everyone uses the Active Threads link at the top right corner. Common mistake thou.
May 28, 2003 at 5:18 am
quote:
dk-fr, do your environment have , let say a german SQL server installation and a italian/french client for example?If you say ...
May 28, 2003 at 5:14 am
Make sure the "profiledumps" directory exists on the C: drive.
May 28, 2003 at 4:36 am
This is similar to the previous except I prefer to use ISNUMERIC function when testing a value.
CREATE FUNCTION dbo.fn_StripAlpha (@val VARCHAR(8000))
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @valout...
May 28, 2003 at 4:33 am
I think you are looking for this
SUM(CASE SC.TestShortName WHEN 'HMRP' THEN SC.TestScore ELSE NULL END) AS PreTest,
SUM(CASE WHEN SC.TestShortName = 'HMRP' AND SC.TestScore < 70 THEN SC.TestScore ELSE NULL END)...
May 28, 2003 at 4:22 am
If you use any roles then you may not get those listed. Take a look at this script to help in that area.
http://www.sqlservercentral.com/scripts/contributions/268.asp
May 28, 2003 at 4:15 am
I agree, open EM and look at the objects and see if any have the same name but different owners. It is a best practice to make sure all objects...
May 28, 2003 at 4:07 am
Please do not cross post. As for the answer to your question, it should be. To be absolutely sure you get the desired results set up a test scenario in...
May 28, 2003 at 4:01 am
No there is no fix as it is sampling the data for best fit and if the sheet was very large would take a long time to accomplish the task....
May 28, 2003 at 3:53 am
Here is one of the threads where that is being discussed (it is very large)
May 28, 2003 at 3:49 am
This would be the query
SELECT
A, B, C,
(CASE WHEN D IS NULL THEN '' ELSE D + ';' END) +
(CASE WHEN E IS...
May 28, 2003 at 3:19 am
Usually it is to add an extra layer of security. However, if you are using in SPs then I would write the code directly to the SP as there is...
May 27, 2003 at 6:47 am
Also, check the Windows Event Logs. Many times backups write more information there.
May 27, 2003 at 6:44 am
If you are doing this in QA then
1) Tools->Options
2) "Results" Tab
3) Uncheck "Print column headers (*)"
4) Press "OK"
Also, you may want to do
SET NOCOUNT ON
in the batch like...
May 27, 2003 at 4:40 am
Viewing 15 posts - 2,911 through 2,925 (of 7,429 total)