170 reputation
16
bio website softwarecarpenter.com
location United States
age 29
visits member for 2 years, 11 months
seen 2 days ago

Hard working, doing what it takes to get the job doneAir Jordan XI


Nov
6
comment Copying View in Management Studio
@karbon question is very vague is all I was stating. I did not take away that he did the table copy . Regardless simple solution
May
21
awarded  Caucus
May
21
awarded  Constituent
Apr
21
awarded  Autobiographer
Sep
17
revised Should developers be able to query production databases?
updated grammar mistake
Aug
8
comment Copying View in Management Studio
Yes, from one server to another server. Views are based on tables. The method you described will create a new view, but if applied on another server the tables need to exist as well or linked server's need to be setup. Based on the question it is hard to assume that the tables exist on the other server. This is all I am pointing out.
Aug
8
comment Copying View in Management Studio
Does the same schema exist on both servers? If not then the view may not work if applied to the other server. You can check the view's dependencies by right clicking the view and selecting dependent objects to ensure the other server has the need objects.
Aug
8
awarded  Critic
Aug
8
comment Copying View in Management Studio
The view will still need to reference the tables on the original server. Your answer is assuming that the tables inside the view exist on the other server. Are you suggesting creating the view this way will reference the original server and tables?
Apr
25
awarded  Editor
Apr
25
revised Should developers be able to query production databases?
Updated to include possible fact that developer would need a license to connect to server.
Apr
25
comment Help with this query
Nice answer with explanation! I saw previous answer and was not sure why you provided the count(*) option, but makes complete sense now.
Apr
25
comment A good SQL sniffer
It depends on the interval set for refresh if using to see every sql statement being run. I beleive if set to 10 secs or under then you will impact performance. Otherwise SQL profiler has built in trace templates and is used to find performance issues. UI does not make it a performance problem either same issue can occur running powershell script. Valid point though to watch out for.
Apr
25
comment Help with this query
+1 for suggesting possible problem and maybe leading person to some discovery and suggesting best practice regarding joins. Sometimes the exact query that will work is given , but explanation or other suggestions are left out. No offense to anybody.
Feb
1
comment Executing Stored Procedure that accesses another SQL instance
You mentioned you came across the link sommarskog.se/grantperm.html in your answer below. That is the same blog I posted in the answer I suggested. "This guys blog should answer or provide everything you need. sommarskog.se/grantperm.html#EXECAScrossdb"; Maybe you were just re-referencing for others. I agree it is a good blog and read. Good Luck!
Feb
1
comment Executing Stored Procedure that accesses another SQL instance
Note here that individual owners do not have to be physical persons, but it could be a generic login for each database. You do not have to grant the entire database over. If you don't trust the sysadmins on the other database then insist on certificate signing.
Jan
30
answered Executing Stored Procedure that accesses another SQL instance
Jan
13
awarded  Supporter
Jan
7
awarded  Teacher
Jan
7
answered Should developers be able to query production databases?