Viewing 15 posts - 181 through 195 (of 1,479 total)
Since you didn't specify the table's name in the sub query, SQL Server got the value from the outer query. In order to avoid this, you should specify the...
November 18, 2013 at 7:49 am
I don't have any experience that I can share with you, but I can explain why I don't use it. The main reason that I don't like using cascading...
November 18, 2013 at 6:27 am
I assume that you want to log changes of login settings on the server level. If I'm correct then you can do it with server level DDL trigger for...
October 23, 2013 at 6:54 am
You have to be logged in to the server that you want to query. Another option is to use login to 1 server and use linked servers or openrowset...
October 22, 2013 at 8:31 am
The short answer is – no you can't. A view is a SQL statement that selects records from another. If the record exists, it will show it. ...
October 22, 2013 at 3:55 am
This was already answered in a different thread that you opened - http://www.sqlservercentral.com/Forums/Topic1476962-1292-1.aspx?Update=1. Pleas open one post per question.
Adi
July 24, 2013 at 4:27 am
It isn't clear if you are working with SQL Server 2000 or SQL Server 2008. I'm not sure if IDENT_CURRENT function existed in SQL Server 2000 and I can't...
July 24, 2013 at 4:23 am
I've checked it with sys.sql_modules. Was surprised to find 2 procedures with the wrong setting options. Those procedures have nothing to do with the tables that I want to...
July 23, 2013 at 3:33 am
Thank you for your response. My main concern is because few years ago I didn't do check it properly and ended up disabling one of the application. ...
July 23, 2013 at 1:18 am
Yes. When I say physical memory I mean RAM and when I say disk I mean harddisk. Sorry, English is not my native language:-)
Adi
July 22, 2013 at 1:46 pm
The operating system works with memory and paging file. The paging file is located on the disk, and when there is not enough physical memory left, the operating system...
July 22, 2013 at 12:29 pm
SwePeso (7/20/2013)
Why not use the OUTPUT clause?
Output clause works can output the data to the screen or to a table. It can't output the data into a variable....
July 22, 2013 at 12:20 pm
Jeff Moden (7/20/2013)
Adi Cohn-120898 (7/9/2013)
July 22, 2013 at 12:18 pm
Don't run the if exists statement because 2 sessions can run at the same time and both will get 0 and try to insert the same record. Also this...
July 16, 2013 at 2:52 am
Jeff – Sorry for disappearing, but for some reason I missed your response. What I wanted to do was very simple. I was working on improving performance on...
July 9, 2013 at 9:31 pm
Viewing 15 posts - 181 through 195 (of 1,479 total)