Viewing 15 posts - 1,366 through 1,380 (of 1,838 total)
if you just want the stored procedures and no data, probably your best bet is scripting:
From within Management Studio, in the Object Explorer, expand your database, expand the Programmability folder,...
October 31, 2014 at 3:12 pm
Developer Edition has the functionality of Enterprise Edition, but the licensing for it dictates that you cannot use it in a production type of environment, only development and test environment....
October 31, 2014 at 2:57 pm
Chowdary's (10/31/2014)
when i installed the sql server for SQL Agent Server i have selected account as SYSTEM ,After installing the Instance that SQL Agent server is showing...
October 31, 2014 at 1:54 pm
If the login failed, then there won't be a session for you to use the DMVs against. Typically you'd find that kind of information in: sys.dm_exec_sessions in the program_name...
October 31, 2014 at 1:24 pm
I think your ANDs and ORs may be getting mixed up somewhere, the logic in each WHEN looks confusing, maybe parenthesis could help? Also, you say there are 3...
October 31, 2014 at 12:56 pm
That is nothing to worry about, it's just your application performing some kind of connection pooling. See this article about common things you will see in a trace:
http://www.sqlteam.com/article/examining-sql-server-trace-files
In connection...
October 31, 2014 at 12:13 pm
John Mitchell-245523 (10/9/2014)
The question assumes that XACT_ABORT is set to OFF.
When I first started working with SQL Server this behavior drove me nuts, so I definitely remember it. It...
October 9, 2014 at 10:20 am
...I'm still waiting for an SP4 for SQL Server 2008 and I hope we get one soon...
Actually both are available.
release announcement for 2008 R2 SP3:
release announcement for 2008 SP4:
October 2, 2014 at 10:14 am
peter-757102 (9/23/2014)
September 23, 2014 at 6:52 am
troy.smyrnios (9/19/2014)
In two words - regression testing.It is a costly endeavor, even for those systems that aren't considered "regulated".
I second that! It takes time to evaluate current software against...
September 19, 2014 at 10:44 am
qbrt (9/9/2014)
First, you can run reports directly against the schema since the data is de-normalized and optimized for reporting.
So, isn't the star formation created for the data actually "normalized"? Not,...
September 9, 2014 at 10:47 am
Service Broker is a bit awkward to comprehend at first, even once you get it working. But I think the hardest feature to learn is Analysis Services. It's...
July 18, 2014 at 8:36 am
RonKyle (7/17/2014)As you said, Access may be often misused. I would NEVER use it as a front end to a "real" database, only an Access one.
That's your choice. ...
July 17, 2014 at 12:17 pm
Andy touched on one of the biggest problems with Access, the frequent need to compact/repair. Someone else also mentioned that it's limited in how many concurrent users it can...
July 17, 2014 at 10:35 am
Sergei Yakovlev (7/9/2014)
The FileID column does not look like FilePath column.
I agree... I see we're back to trying to read Andy's mind to determine what he really wanted to ask...
July 9, 2014 at 10:46 am
Viewing 15 posts - 1,366 through 1,380 (of 1,838 total)