Forum Replies Created
Viewing 15 posts - 541 through 555 (of 1,189 total)
-
RE: SSRS Report Manager - differences between development and production
MyDoggieJessie (3/17/2014)
Do other reports work/render properly?Are you 100% certain the data sources are set correctly? It's typical when deploying SSRS reports from BIDS to turn off the "overwrite data...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Filtering Extended Events data
Lowell (3/14/2014)
yes you can filter on Database_id or database_name, the same way you could with a server side trace.here's a screenshot using 2012's GUI to build an extended event session:
Thanks!
Is...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: T-SQL SELECT..INTO
timwell (3/11/2014)
ronmoses (3/11/2014)
Stewart "Arturius" Campbell (3/11/2014)
ronmoses (3/11/2014)
The answers appear to suggest that the following is true:"The columns in new_table are created in the order specified by the select list."
However, http://technet.microsoft.com/en-us/library/ms188029.aspx...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Map login to users
I found this script useful:
http://weblogs.sqlteam.com/billg/archive/2010/07/08/Scripting-out-SQL-Server-Logins.aspx
I'm not sure if it will solve your exact problem in its given form, but I suggest that you review it for ideas. And of course...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: T-SQL SELECT..INTO
Koen Verbeeck (3/11/2014)
Ed Wagner (3/11/2014)
The identity got me.Oooh. Sounds like an exciting thriller.
Ha ha ha. Thanks, that made me laugh.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: SQL 2012 Upgrade Advisor trace files and SQL batch files
Great, thanks again for all of your help!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: SQL 2012 Upgrade Advisor trace files and SQL batch files
I've tested out the replay trace and have a couple of follow-up questions I hope you can help me with.
1. The trace (TQL Replay) template that has the settings generates...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: SQL 2012 Upgrade Advisor trace files and SQL batch files
Many thanks, sqlbuddy and Grant!
This is very helpful information.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Not able to access database - but what object is being sought?
Erland Sommarskog (2/28/2014)
So how does that piece of code look like? What line does the error message point to?By chance, does the procedure have an EXECUTE AS clause?
Hello Erland, thanks...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Not able to access database - but what object is being sought?
MyDoggieJessie (2/28/2014)
Has the user been mapped to the database? If not, that's most likely the cause of your error. If you're concerned about granting permissions. If the...-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Customizing Report Manager Interface
doug.brown (2/19/2014)
AFAIK, the interface is not configurable in terms of adding new columns. You could enter "Details" into the Description (in Properties/General tab) of any details reports, as the Description...-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: How to check that Reporting Services is working
MyDoggieJessie (2/13/2014)
Not sure if this helps but I did find a link that might offer you a direction to go in:http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx
Thanks for this information!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Where does Reporting Services store reports?
Thanks for this information!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Database checkbox in login mapping disappears
Thanks, everyone.
So sorry for the super-late reply. But the issue was a disabled user as suggested. I noticed it again today, which is how I came back to this...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
RE: Memories of 2013
Best SQL Server memory? 72 GB of RAM courtesy of our systems dept. 🙂
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 15 posts - 541 through 555 (of 1,189 total)