Viewing 15 posts - 76 through 90 (of 129 total)
Execute this "EXEC sp_MSdbuserpriv N'ver'"
If same error occurs refer to: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ327424
Although it refers to SQL Ser 7 it may be relevant to you.
If it does not give back a...
October 13, 2004 at 12:19 am
Watch out for Domain Administrators too. Often, they are included int he Administrators group.
October 6, 2004 at 5:06 pm
You could look at :
http://www.nwnetworks.com/cluster.html
(and I think you might need to know about installation and creation of clusters, which will enlighten you about how the disks are viewed from...
October 5, 2004 at 12:31 am
Or....
Using EM, copy (right click on existing UDF), move on over to Master/UDF's. Right Click "Create new UDF" clear the code window and paste into the code window.
When EM does...
October 3, 2004 at 11:45 pm
You need to supply the full code (SP & UDF).
If the ParseString udf returns a table you may have to think differently.
DB
September 23, 2004 at 12:51 am
Remove the two pctupuser's in the SQL statement and OK it. They'll come back - so that's a no
Your Database name is "pctupuser" and the table/s owner name is "pctupuser"...
September 21, 2004 at 11:15 pm
MDAC is not upwards compatible ?
I have been using it since it came out and have not experienced any issues.
We recently released a new GIS system into our SOE and...
September 16, 2004 at 12:30 am
Try defining a linked server without a space in the name.
August 18, 2004 at 12:02 am
Well how about that ? You live and learn hey ? (Go Aussie)
August 9, 2004 at 3:36 pm
XP_FIXEDDRIVES does see the shared drives in a cluster here. The drive configuration may be an issue - I think XP_FIXEDDRIVES only returns info on Fixed hard drives.
Do you have...
August 5, 2004 at 12:48 am
And I'm pretty sure you can't import a Corel Photopaint file into SQL Server (ho hoh ho)
August 5, 2004 at 12:28 am
Done about 8 million text/integer using BCP which was fairly fast and painless, used the Import Data Wizard for a 3 million row table - which was a bad thing...
August 5, 2004 at 12:15 am
Don't know about Analysis Services but you only have 30 seconds, and only ever 30 seconds in EM for your query to return data.
If you have an affection for the...
August 4, 2004 at 11:46 pm
Ala Books On Line:
Executes the specified pass-through query on the given linked server, which is an OLE DB data source. The OPENQUERY function can be referenced in...
August 2, 2004 at 3:42 pm
Viewing 15 posts - 76 through 90 (of 129 total)