Viewing 15 posts - 211 through 225 (of 260 total)
That's good to hear 🙂
It is safe to delete old .trc files(It doesn't impact your SQL server Services). In general these files are created by SQL Server to save events...
January 10, 2014 at 1:23 pm
By default SSMS generate Script task has "Continue Scripting on Error" set to false. You can change it to TURE by clicking on Advanced Button.
Please see attached screenshot for what...
January 9, 2014 at 2:40 pm
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2894115&kbln=en-us
Highlighted in the attachment is what you need if you are planning to Install CU7, as you've got 32 Bit server.
January 9, 2014 at 2:24 pm
Looks like "11.00.3128" is SP1+ 2793634 Hotfix.
2012 SP1 has some nasty bugs w.r.t Memory(See this blog post if you are curious...An interesting read http://lokna.no/?p=1251) .
Personally, I would recommend to...
January 9, 2014 at 1:54 pm
What's the current Build # your SQL Server is running at?
Looks like you are running on 32 bit architecture from the message posted.
Computer type is Intel(R) Core(TM) i3 CPU 530...
January 9, 2014 at 1:00 pm
Also...may be...you can consider to limit the size of your error log besides recycling on regular basis, since you are running on SQL Server 2012.
http://www.sqlskills.com/blogs/paul/limiting-error-log-file-size-in-sql-server-2012/
But, First of all...I would worry...
January 9, 2014 at 11:49 am
You would need to schedule a job of type "SSAS Command" after scripting out your regular SSAS Backup task. Below link has details which might help you...
January 8, 2014 at 12:07 pm
Nothing more from Logs? The info provided doesn't look much useful to me for troubleshooting...Try investigating more Log entries(Both Windows App and SQL Error Logs) for clues.
Btw, what do you...
January 3, 2014 at 12:28 pm
What does your Application log(From Event Viewer) and latest SQL Server Error Log says?
January 3, 2014 at 12:04 pm
Per Confio - When Microsoft Access attempts to join a SQL Server table with a local Access table, Access will retrieve every row from SQL Server and perform the join...
January 2, 2014 at 2:21 pm
Grant Wrote a wonderful article on statistics early this year, explaining stats on Temp Tables/Variables.
From his article:
Are statistics created on temporary tables?
Yes. The major difference between a table variable and...
January 2, 2014 at 9:46 am
sreekanth bandarla (12/31/2013)
Also, SQL Server Error Log will have an entry something similar to "The SQL Server Network Interface library successfully registered the Service Principal Name (SPN)..............." when it got...
December 31, 2013 at 8:43 am
http://www.sqlservercentral.com/Forums/Topic724433-149-1.aspx#bm724477
Also, SQL Server Error Log will have an entry something similar to "The SQL Server Network Interface library successfully registered the Service Principal Name (SPN)..............." when it got restarted last...
December 31, 2013 at 8:34 am
This could be SPN issue(Failing at the double hop scenario). when Kerberos is not configured correctly the creds are not carried when the packet hops from the one machine to...
December 30, 2013 at 11:57 am
Viewing 15 posts - 211 through 225 (of 260 total)