Viewing 15 posts - 301 through 315 (of 1,654 total)
Sorry, I can't help you with your problem applying the patch, but personally I wouldn't do it that way anyway. Restoring a master database to antoher server is always tricky...
[font="Verdana"]Markus Bohse[/font]
June 2, 2009 at 7:20 am
bhuvnesh.dogra (6/2/2009)
Actually ,currently we have low configuration MAchine
and now we need to clone the databases to High config Machine.
bascially replica of current one to new server .
I...
[font="Verdana"]Markus Bohse[/font]
June 2, 2009 at 6:19 am
sivark1 (6/2/2009)
Hi
i have some 20 databases in sqlserver2005 how i need to check total size of all databases in the server
individual size i can check with sp_helpdb
There...
[font="Verdana"]Markus Bohse[/font]
June 2, 2009 at 6:14 am
Like Adi already said, we don't really know what your question is. But since you start about a placing an index I notices at least one problem. Indexed views have...
[font="Verdana"]Markus Bohse[/font]
June 2, 2009 at 5:31 am
Could it be that your backup device contains more than one backup?
I see you're using the option WITH FILE =1, which will restore the first backup which has been...
[font="Verdana"]Markus Bohse[/font]
June 2, 2009 at 5:22 am
About the job notification for failed jobs, did you configure the SQL Agent to use the profile? Also very important, after any change to the profile you need to restart...
[font="Verdana"]Markus Bohse[/font]
June 2, 2009 at 1:28 am
sudhakara (5/29/2009)
[font="Verdana"]Markus Bohse[/font]
May 29, 2009 at 4:58 am
That's totally normal. During installation of SQL 2005 you cannot choose a separate drive for logfiles, so the system databases always have datafiles and logfiles in the same directory. You...
[font="Verdana"]Markus Bohse[/font]
May 29, 2009 at 4:54 am
Colin Hamilton (5/28/2009)
I'm onsite with a customer today and it’s the first time I've been able to look at their DB. They are a small organisation with no more than...
[font="Verdana"]Markus Bohse[/font]
May 28, 2009 at 7:42 am
ming_dong (5/15/2009)
We never had this issue if client only has publisher and subscribers. This issue only occurred after distributors were added. Another strange thing is that this issue...
[font="Verdana"]Markus Bohse[/font]
May 28, 2009 at 5:21 am
This query is a bit simpler:
SELECT OBJECT_NAME(Id) AS [TableName],
rows as [RowCount] FROM sysindexes
WHERE indid 0
ORDER BY [TableName]
[font="Verdana"]Markus Bohse[/font]
May 28, 2009 at 3:32 am
Did you try Books Online?
http://msdn.microsoft.com/en-us/library/aa337552(SQL.90).aspx
[font="Verdana"]Markus Bohse[/font]
May 27, 2009 at 7:10 am
arup_kc (5/26/2009)
Hi markus,I should admit that still I have not faced any real time application of this query. This is simply my inquisitiveness.
In case you ever need such a...
[font="Verdana"]Markus Bohse[/font]
May 27, 2009 at 3:46 am
Joe Doherty (5/27/2009)
I had 4gb of ram in my database server. Windows 2003 enterprise 32 bit. Task manager showed I was using 2.7gb. I was also using /3gb.
I installed another...
[font="Verdana"]Markus Bohse[/font]
May 27, 2009 at 2:38 am
pkalva (5/26/2009)
Hi Marcus,Does sql2005 has any special restrictions?
Thanks!
Pallav
Generally speaking, security is a lot tighter in SQL 2005. Also xp_fileexist is an undocumented procedure and MS won't...
[font="Verdana"]Markus Bohse[/font]
May 26, 2009 at 10:54 am
Viewing 15 posts - 301 through 315 (of 1,654 total)