Viewing 15 posts - 361 through 375 (of 812 total)
you can refer to this post
http://www.mssqltips.com/tip.asp?tip=1145
and can select the required date formate as per your requirement
----------
Ashish
February 7, 2011 at 3:03 am
you should have configured your databafile with autogrowth setting.
Go to your database properties and change the files setting growth with Autogrowth in percentage or FixedSize(in MB).
As well dont...
----------
Ashish
February 7, 2011 at 1:54 am
Good to see it worked.
But shrinking the database should not be treated as solution to reduce the ldf/mdf file size. In fact you should first investigate why the database...
----------
Ashish
February 4, 2011 at 7:30 am
you must have one localadmin account in your system and it could be domain admin account.
Or you can try to add that account in proper windows group which have the...
----------
Ashish
February 4, 2011 at 4:59 am
The database requires 9538633728 additional free bytes, while only 9327198208 bytes are available
But the database size is 177 MB only.
The error is explanatory itself.
If you convert requires kb(9538633728) and...
----------
Ashish
February 4, 2011 at 3:41 am
Yes I am also one of the member of windows active directory group. It's not logging in with BUiLT/Administaration rights too.
It should not be the case. Can you please paste...
----------
Ashish
February 4, 2011 at 3:32 am
if your sql instance is mixed mode, then you must have some windows account which have the SA permission. Login with that account and reset the password for sa login.
----------
Ashish
February 4, 2011 at 3:10 am
is the database having filegroups(ndf)?
If so, are all the file groups online when you taking backup.
It could be the possibility that database have a specific filegroup which is...
----------
Ashish
February 4, 2011 at 2:46 am
Fresh installation doesn't work in such scenario.
ohhh you know this.....
then you should be considering the approach accordingly.
----------
Ashish
February 4, 2011 at 2:39 am
while creating the login, give the default database name as the one you want the user need to be connected. And also make sure you give the public access on...
----------
Ashish
February 4, 2011 at 2:09 am
r u sure there is no dts/ssis or job scheduled to run every x min of interval or retry after failure?
Also you can run profiler with specific database and SP...
----------
Ashish
February 4, 2011 at 1:47 am
if this database is in 2008(i know u raised this question in 2005 forum), and if record get deleted very recently then you can use sql server reports which will...
----------
Ashish
February 4, 2011 at 1:43 am
How to resolve? Renaming the drive wont' work i guess.
No, renaming the drive will not work.
Before considering the option to resolve this issue, consider the point that do you...
----------
Ashish
February 4, 2011 at 1:35 am
'E:\MSSQL2K\MSSQL\Data\master.mdf'
check if the drive is available. Seems like the problem with Drive/location.
----------
Ashish
February 4, 2011 at 1:23 am
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO
is exactly how to do it. As I have many times.
Agree cath, but it will not remove the original name of the server which you will...
----------
Ashish
February 3, 2011 at 4:20 am
Viewing 15 posts - 361 through 375 (of 812 total)