Viewing 15 posts - 46 through 60 (of 196 total)
normturgeon (8/5/2013)RAISERROR 44446 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblPolicy''.'
I'm working with SQL Server since SQL 2000. I did not...
August 5, 2013 at 9:53 am
Krishna1 (7/30/2013)
Hi allI have created some permenent tables(mistake) tables in temp db. But can not view them in managment studio. How do i view and delete them all?
Have you tried...
August 4, 2013 at 5:11 am
That is a very good point to be aware of. I did not think about that.
August 3, 2013 at 10:23 pm
nothing via google? https://www.google.at/?gws_rd=cr#output=search&sclient=psy-ab&q=An+instance+with+the+same+name+is+already+installed+on+this+computer.+To+proceed+with+SQL+Server+Setup%2C+provide+a+unique+instance+name.&oq=An+instance+with+the+same+name+is+already+installed+on+this+computer.+To+proceed+with+SQL+Server+Setup%2C+provide+a+unique+instance+name.&gs_l=hp.3...528.528.0.1156.1.1.0.0.0.0.0.0..0.0....1...1c.1.23.psy-ab..1.0.0.8i0u7jt5srY&pbx=1&bav=on.2,or.r_qf.&bvm=bv.50165853,d.Yms&fp=c234bbd9317c9ebd&biw=1280&bih=885
As you seem to be under stress, can you install the sql server using a named instance?
August 3, 2013 at 2:26 pm
You declared both variables as an integer. So the result of the division is converted to an integer too.
189/1355 = 0,13948....
This value converted to an integer = 0
Try declaring your...
August 3, 2013 at 1:35 pm
ScottPletcher (8/2/2013)
Yeah, that's crazy.
indeed :w00t: never heard of this too.
I would never rely on the dabase ids beeing the same after restore.
Kick this third party tool and find another one...
August 3, 2013 at 1:24 pm
If I understand it right the EndMonth and EndYear is always a date first of month. Let's take this as EndDate.
StartMonth and StartYear is a date that is a number...
August 3, 2013 at 1:19 pm
James Mace (8/1/2013)My question is, when the backup set list is not populated, is there a way to populate it or do I have to run my restore manually from...
August 3, 2013 at 12:59 pm
ähhhmmm.... what???
Please describe exactly what you do.
Add your sql code too. If using the gui describe step by step and mouseclick by mousecklick what you are doing.
Explain what your target...
August 3, 2013 at 12:51 pm
Like Jeff I recommend you to add an parameter to your stored procedure and get the top x (10 in your case) within the procedure. In SQL 2012 there is...
August 3, 2013 at 12:47 pm
I'd say you are the second 🙂
I'm setting up an Always On Group these weeks.
I also have some large tables that are partitioned by month. The database ist part...
August 3, 2013 at 12:36 pm
Maybe you get some useful information about what locks the table using sys.dm_tran_locks (http://msdn.microsoft.com/en-us/library/ms190345%28v=sql.90%29.aspx)
There are some other Transaction Related Dynamic Management Views and Functions that might help you: http://msdn.microsoft.com/en-us/library/ms178621%28v=sql.90%29.aspx
July 30, 2013 at 7:15 pm
Maybe the article Finding lost or forgotten SQL Servers will give you a single tool for your tool box: http://www.sqlservercentral.com/articles/powershell/72809/
July 30, 2013 at 6:56 pm
You can move the files of system databases but - depending on which database - a special procedure is needed. Have a look here: http://msdn.microsoft.com/en-us/library/ms345408%28v=sql.90%29.aspx
July 30, 2013 at 6:36 pm
Viewing 15 posts - 46 through 60 (of 196 total)