Viewing 15 posts - 91 through 105 (of 789 total)
Are you trying to connect with SSMS to that instance !?
Seems that your instance name is incorrect!!!
In Express Edition you should connect like this:
ServerName\InstanceName
or
YourComputerName\InstanceName
April 30, 2010 at 9:31 am
CirquedeSQLeil (4/30/2010)
Dugi (4/30/2010)
Henrico Bekker (4/29/2010)
Nice to know! one more question: is your sa account enabled and what is the password? 😛
It is not documented by Steve, so I guess he...
April 30, 2010 at 12:39 am
Henrico Bekker (4/29/2010)
Nice to know! one more question: is your sa account enabled and what is the password? 😛
It is not documented by Steve, so I guess he doesn't have...
April 30, 2010 at 12:33 am
GilaMonster (4/29/2010)
Lowell (4/29/2010)
April 29, 2010 at 4:19 pm
WayneS (4/29/2010)
D.Oc (4/29/2010)
My bet is on GB's not TB.Especially singe "G" is right under "T" on the keyboard...
I think we choose the situation, now what any solution scenario for this...
April 29, 2010 at 9:15 am
GregoryF (4/29/2010)
Are you really sure it's 800TB and not 800GB?SQL 2008 only support 512TB Databases
http://msdn.microsoft.com/en-us/library/ms143432.aspx
So does SQL 2005
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx
No SQL Server supports over 512 TB, take a...
April 29, 2010 at 7:52 am
If the situation is true, it would be very interesting about DB architecture info ( data files & log files architecture ) :w00t::hehe::w00t:
April 29, 2010 at 7:47 am
According to max specifications of SQL Server how it can be log file 100 TB ( max spec. 2TB)! ? !
April 29, 2010 at 7:33 am
Just curious, did you have latest updates for SQL Server ( SPs and other Comulative Updates)!?
April 28, 2010 at 7:39 am
9000 * 5000 = 45 000 000 records and growing up if they have new customers hahaa you should look for the nice performance with those records in a one...
April 16, 2010 at 4:37 pm
Interesting situation, I can see that for every new customer, the new table will created ...will it continue or it stops at 5000th customer's table, and you just trying to...
April 16, 2010 at 3:27 pm
Works nice in SQL Server 2008 x64!
It would be better if you add the IP info!
Thanks for sharing 😎
April 15, 2010 at 2:26 am
For the beginning check this http://www.sqlservercentral.com/articles/DBA/68526/
Never say Never, Never is too late...everyday we learn new things....!
And take a look one quote here
I wish you success....!
April 4, 2010 at 12:37 am
vaibhav.tiwari (3/30/2010)
Thanks for the suggestion and got the hint i can do it by row_number function.Thanks again
Let us know how you did!?
March 30, 2010 at 9:02 am
Viewing 15 posts - 91 through 105 (of 789 total)