Viewing 15 posts - 241 through 255 (of 278 total)
As per http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx it is only available in the Enterprise version....
March 11, 2009 at 9:46 am
If you have the users connect to the node specific IP address, you are not doing anything to "help" in case of a failover, as a manual reconnect to...
March 10, 2009 at 11:26 am
From your description this sounds more like statements within a TRANSACTION, either all commit or all fail..... There would be no need to call different SP's for that and if...
March 10, 2009 at 7:52 am
Yes, calls to other SP's return to the calling one.... take it as if they were just subroutines called.. jeez... this takes me back 20+ years programming in BASIC 😀
March 10, 2009 at 7:12 am
...and then of course remember to restart the SQL services.....
March 10, 2009 at 7:10 am
For starters, you could do a little search..... this is an often asked question, lastly discussed here:
http://www.sqlservercentral.com/Forums/Topic293409-148-1.aspx
here
http://www.sqlservercentral.com/Forums/Topic603932-148-1.aspx
and many more....
March 5, 2009 at 8:14 am
mrhassell (3/4/2009)
SAN is a 'storage area network', which is great for storing backups, but running production databases from such a complicated environment is bad practice. :w00t:.
I believe this...
March 5, 2009 at 8:11 am
The licensing is per end user, ie, all your users using the application. This same principle is as if you have a web server accessing a SQL Database. This is...
February 20, 2009 at 7:18 am
yup... realized that... see my previous post...
February 19, 2009 at 8:48 am
Well, found this http://blogs.techrepublic.com.com/datacenter/?p=192
So apparently the trick with sp_dropserver/addserver and restarting the SQL services does accomplish what you need?
February 19, 2009 at 8:44 am
um....
sp_dropserver will "remove a server from the list of known remote and linked servers on the local instance of SQL Server"..... so it will not affect at all your running...
February 19, 2009 at 8:32 am
why post again for something you just started yesterday here: http://www.sqlservercentral.com/Forums/Topic660118-146-1.aspx......
February 19, 2009 at 6:45 am
Regarding 1, yes it could be a schedule stored proc that brings the data together into the 1 reporting table.
On 2, the big issue is if data is updated or...
February 17, 2009 at 2:07 pm
Other thing to check is in the Local Group Policy Security Settings (Start/Programs/Administrative Tools/Local Security Settings) in the the Lock Pages (Local Policies/User Rights Assignment/Lock Pages in Memory). There you...
February 16, 2009 at 10:50 am
And, on question #3, depending on your setup, changes on the Principal are usually reflected almost instantly on the mirror, not within minutes, so yes, any data deleted from Principal,...
February 16, 2009 at 9:57 am
Viewing 15 posts - 241 through 255 (of 278 total)