Viewing 15 posts - 31 through 45 (of 59 total)
Looks like the web page can't handle data returned from your server. For example, if the web page expect one field to have a value but the returned data is...
February 19, 2011 at 7:19 am
Did you try right click on your SQL Server service and select property?
What error did you receive when trying to connect to SQL with Windows Authentication?
February 19, 2011 at 6:58 am
on the source server, run the following script to find out where your back files are:
select database_name,backup_start_date,physical_device_name
from msdb.dbo.backupset bs
inner join
msdb.dbo.backupmediafamily bmf
on bs.media_set_id = bmf.media_set_id
where database_name = <your db name>
order by...
February 19, 2011 at 6:35 am
db_datareader role will not be able to run DBCC. If you don't want user to have more than db_datareader permission, why do you want user to run DBCC? Can't expect...
February 11, 2011 at 8:46 pm
DBCC showfilestats requires membership in the DB_owner fixed database role or Sysadmin fixed server role.
February 2, 2011 at 10:44 pm
thecoding (2/2/2011)
In our case, which one is better?
It depends. If the two type of users are competing with CPU or memory resource, resource governance will help. If they are more...
February 2, 2011 at 10:35 pm
If you have enabled trace flag 1204 or 1222 on your server, you should be able to get dead lock details from the error log. Otherwise, I don't think you...
January 18, 2011 at 10:37 pm
Is it possible to post your current script? That way we can have a better idea of what you are trying to achieve and what might be done to imporve...
January 16, 2011 at 10:51 pm
hemangmehtaa (1/13/2011)
We have 2 databases db1 and db2, they may or may not be on the same server.
Now db2 has got a particular table called foo. when db2 enters a...
January 16, 2011 at 10:40 pm
If you really want the results as you described, add an ID (identity) column onto color and taste tables and then run the following script
select
* ...
January 16, 2011 at 10:25 pm
Yes, different instances can have different level of patches on the same server.
January 13, 2011 at 11:12 pm
One question I would first ask is how will you analysis/retrieve the data (if you have it, either trace file,tlog file etc) when required (for example to find out at...
January 13, 2011 at 10:53 pm
Steps I would take:
1. Test DBMail is working via send a test email. If Test email works, go to step 3
2. run following sciprt to see if SQL is/was attempting...
January 6, 2011 at 11:37 pm
You can't set up logshipping betwee 2000 and 2008 via SSMS. You need to write scripts to do so.
January 6, 2011 at 11:19 pm
Based on the LSN info you posted, I would exptect to see the FirstLSN for the differencial backup to be 20000026339700443 rather than 19000448530800001.
What version of SQL are you running?...
January 6, 2011 at 10:54 pm
Viewing 15 posts - 31 through 45 (of 59 total)