Viewing 15 posts - 16 through 30 (of 55 total)
There are numerous tutorials on internet on how to connect to sql server. Go through them.
October 15, 2011 at 8:13 am
Get your windows team and hardware vendor involved. I have seen these issues on SAN and upgrading the firmware resolved the issue.
October 14, 2011 at 2:34 am
try passing the user name as [david.ch]
login name enclosed in square brackets.
October 14, 2011 at 2:29 am
You can write a script that copies transaction log backup continuously from production to test and restore them once a week.
Important point is you should not lose a even a...
October 13, 2011 at 9:59 pm
Beginner_2008 (10/13/2011)
No my question is after the secondary database has gone in "Restoring" mode, how to bring to accessible mode?Please suggest.
Not sure what you mean.
If you want...
October 13, 2011 at 9:43 pm
adb2303 (10/13/2011)
does this path exist? If not, change it to one that does exist, or create it... 'C:\myfolder\mytrace'thanks, Andrew
Check if the service account has read/write privilages to that path.
October 13, 2011 at 8:29 am
forsqlserver (10/13/2011)
gail may I know reason?
Your backup file contains only used pages from your data and log files.
Your database's size is 1.6 TB. This doesnt mean the entire space will...
October 13, 2011 at 6:48 am
Knowledge Hunter (10/13/2011)
Eg: select * from table
Error: Invalid object
select * from dbowner.table
returns result.
I want the query to be executed without using the dbowner in the identifier...
October 13, 2011 at 6:40 am
Please post the sql that you are trying to execute and the error message that you are getting.
October 13, 2011 at 12:47 am
you can use xp_cmdshell to create a copy script and schedule to run.
xp_cmdshell 'copy d:\backups\*.* \\remoteserver\backups\'
October 12, 2011 at 11:49 pm
what about guest account? have you checked that?
October 12, 2011 at 5:53 am
change the owner of the objects owned by that user.
sp_changeobjectowner 'tablename','dbo'
When your objects are owned by dbo, you do not need to prefix this owner. For any other owner, you'll...
October 12, 2011 at 5:50 am
try restoring using a query
restore database mydb from disk='<your path here>\<your backup file name>'
October 12, 2011 at 5:45 am
Anand.A (10/12/2011)
i create user-name and password for sql server 2008 but this user can access all the db
but i want to create user-name and password that user-name can access only...
October 12, 2011 at 5:40 am
dmvs dont store information about activities carry out by a particular login.
Trace would be a good solution. Setup a server side trace for a certain duration and then alalyze...
October 11, 2011 at 6:04 am
Viewing 15 posts - 16 through 30 (of 55 total)