Viewing 15 posts - 166 through 180 (of 183 total)
Thank you
My actual doubt now is what is difference between user mapping page(which shows permission like datareader,dbowner etc) and one under database->security->any user.Right click user and click properties.Now u can...
February 5, 2013 at 4:05 am
Thank u.
But i am not clear about two security folder under server and another one under database.In both database role membership is specified.So what is difference between them?
January 29, 2013 at 7:46 am
If i create a file group with read only then how can i insert the values to the table? What is the use of read only file group?
January 21, 2013 at 6:04 am
What if i create secondary file group as read only?
January 21, 2013 at 12:46 am
How can i import from an excel file in sql express 2008 r2?
January 18, 2013 at 9:21 pm
I tried to use tab limited file and the bulk insert query as
BULK INSERT designs
FROM 'D:vt.csv'
WITH
...
January 18, 2013 at 6:28 am
I think comapct edition does not allow multiple connections to same database in network.I want database to be access through network simultaneously for atleast 5 to 10 users.
January 17, 2013 at 10:29 pm
I have sql server express.So SSIS is not available for me.
Here is a sample of csv file i am trying to insert
QueryResult,QueryResult,500,2,46,A,abc,1,NULL,NULL,"date_atnd,time_atnd",,70,NULL,48,NULL
Here date_atnd,time_atnd has the comma in between. So i...
January 17, 2013 at 9:55 pm
thank u for replying.
I have a doubt. All my database have recovery model full. If i do file group backup separately for primary file group regularly and secondary file group...
January 17, 2013 at 4:40 am
Microsoft SQL Server Management Studio version is 10.50.1600.1
And server is sql server 2008 r2 express
January 17, 2013 at 1:00 am
I found that while i restore primary file group in ssms by using only primary file group file backup file i used following script
RESTORE DATABASE [test] FILE = N'test', ...
January 16, 2013 at 10:46 pm
So shrinking only log file will not increase the fragmentation?
January 16, 2013 at 6:43 am
I used the SSMS gui option to restore the file group.
January 16, 2013 at 5:59 am
Yes, Auto close is set to true.The recovery model is full.
January 16, 2013 at 5:37 am
Viewing 15 posts - 166 through 180 (of 183 total)