Viewing 15 posts - 346 through 360 (of 1,292 total)
Check if Named Pipes protocol is enabled and try connecting using the Machinename\InstanceName.
January 8, 2010 at 8:52 am
What ever you see in your system (SSMS) that can be typed and described, alternately you can take a screenshot and attach to your next reply. Do not edit previous...
January 8, 2010 at 7:34 am
Quoting Books online..
The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent.
Ans it does not represent currency symbol...
January 8, 2010 at 7:31 am
Without error details, and how are you trying to restore the DB (SSMS or through SQL command) it is highly unlikely to suggest you since we don't have enough information...
January 7, 2010 at 9:33 pm
Oksana March (1/7/2010)
Personally, I hate it when someone tells me to Google something. Everyone knows that option is there, so it's like they don't want to answer the question.
You may...
January 7, 2010 at 5:45 pm
As Jeffrey suggested, have the SSIS Package scheduled as a SQL Agent job and let the Sproc kickoff the job. Let the users action (clicking a button) call that sproc.
January 7, 2010 at 5:33 pm
The_SQL_DBA (1/7/2010)
Bru Medishetty (1/7/2010)
ALZDBA (1/7/2010)
GSquared (1/7/2010)
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
Servers usually aren't all that loud, but...
January 7, 2010 at 2:45 pm
ALZDBA (1/7/2010)
GSquared (1/7/2010)
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
Servers usually aren't all that loud, but the limit would...
January 7, 2010 at 2:40 pm
Use this.
select [NAME],CREATE_DATE from master.sys.databases
January 7, 2010 at 12:07 pm
The_SQL_DBA (1/7/2010)
Bru Medishetty (1/7/2010)
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
You can start creating databases one by one until...
January 7, 2010 at 12:00 pm
Lynn Pettis (1/7/2010)
Bru Medishetty (1/7/2010)
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
You can start creating databases one by one...
January 7, 2010 at 11:01 am
In short, it can't be done in systems prior to SQL 2008. SQL 2008 has resource governor that enable the Admin to limit system resources to groups.
My suggestion to your...
January 7, 2010 at 10:48 am
Have you checked if the protocols needed are enabled? Check in SQL Server Configuration Manager.
January 7, 2010 at 10:42 am
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
You can start creating databases one by one until it says max...
January 7, 2010 at 10:38 am
Viewing 15 posts - 346 through 360 (of 1,292 total)