Viewing 15 posts - 45,211 through 45,225 (of 49,571 total)
What are you trying to do?
If you're trying to set column names with a variable, it doesn't work that way. What your query is doing is summing the value contained...
August 9, 2008 at 3:27 am
Not management studio. That's just the client tool. The SQL Server service.
Go to Microsoft SQL Server Server on your start menu, all programs. Got to configuration tools and open the...
August 9, 2008 at 3:20 am
Is the SQL server running?
Open surface area config and check that TCP/IP connections are enabled and set to local and remote.
August 9, 2008 at 2:04 am
John Rowan (8/8/2008)
As far as your SQL Server service account, you should generally run it under the local system account unless you SQL Server needs access to network resources.
I don't...
August 9, 2008 at 2:00 am
CrazyMan (8/9/2008)
I tought of this as well, since this is been updated or deleted...
August 9, 2008 at 1:55 am
Mike Alfa (8/8/2008)
Not using /3 GB /userva was definitely unexpected suggestion which I think makes sense due to IIS running on this server.
It has nothing to do with IIS. If...
August 9, 2008 at 1:47 am
CrazyMan (8/9/2008)
Its a java exe file that clears the cache, i saw permission, i have done this before, i have done this on...
August 9, 2008 at 1:42 am
crever (8/8/2008)
This is to allow you to stripe them for speed as well as place them on different drives as space becomes an issue.
Multiple log files don't...
August 8, 2008 at 1:51 pm
Do not use either /3GB or /userva if you are using AWE. You're asking for a unresponsive server.
You do need to enable AWE if you want SQL to use more...
August 8, 2008 at 1:41 pm
Does the SQL server service account have rights to the directory c:\Bond\Bondcli?
Does it have rights to execute tablePKDAO and do whatever that's supposed to do?
What's going to happen if more...
August 8, 2008 at 1:28 pm
May I just observe that you have a rather poor database design there and that you may want to consider normalising it. It would certainly make adding or removing a...
August 8, 2008 at 10:17 am
Pleasure
August 8, 2008 at 10:15 am
Personally, I wouldn't run repair at all unless as an absolute last resort. If the corruption is in only nonclustered indexes, I would prefer to manually drop and recreate the...
August 8, 2008 at 10:03 am
Viewing 15 posts - 45,211 through 45,225 (of 49,571 total)