Viewing 15 posts - 24,226 through 24,240 (of 26,490 total)
Sometimes, I think people think too hard with some of the questions.
😎
September 19, 2008 at 8:55 am
I will throw out my 2 cents. I'd be wary, very wary. Best thing you can do is get your vendor and Microsoft on the phone together and...
September 18, 2008 at 12:34 pm
Unfortunately, the build numbers do not distinguish the different editions of SQL Server.
😎
September 18, 2008 at 12:21 pm
What recovery model are you using on the database, and do you have a current backup (and if approriate, transaction log backups) from prior to the accidental delete?
😎
September 18, 2008 at 12:17 pm
Scott,
This is the article that Jeff wrote and is a good place to start.
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
😎
September 17, 2008 at 10:53 am
Not sure, but I think that there should be a clustered index on the temporary table as well. Not exactly sure which columns. Jeff Moden wrote a nice...
September 17, 2008 at 10:25 am
The trial edition is most likely the Standard Edition with a expiration date, which is not as powerful as the Professional Edition.
😎
September 16, 2008 at 3:43 pm
Can't debug a stored proc in SSMS. You need, if memory serves, Visual Studio 2005 Professional or better.
😎
September 16, 2008 at 2:26 pm
Could have also been caused by a network error. If you have the space on the server itself, it would be better to backup to disk locally, then move...
September 15, 2008 at 3:47 pm
Using your temp tables from the original post, here is the code you are looking for.
with Controls (
ControlName,
HasAccess,
ControlType
)...
September 15, 2008 at 2:57 pm
rian67 ,
Here is what I'd say. The development server needs to be controlled, and supported to fulfill the requirements of the development team. This does not mean that...
September 13, 2008 at 10:08 pm
I have to agree with DavidB, setting up replication is not a developer task. It should be setup by the DBA. Too many things that need to be...
September 12, 2008 at 2:45 pm
Is this nice data in a table already, or do you only have it in a text file?
😎
September 12, 2008 at 1:54 pm
Why not? I don't think any of those require sys admin access to the entire system to be completed. I can see where adjustments might be required, depending...
September 12, 2008 at 1:52 pm
Not saying application developers don't know how to work with SQL Server, they just don't always think about things the same way a DBA.
A DBA has a duty to protect...
September 12, 2008 at 1:34 pm
Viewing 15 posts - 24,226 through 24,240 (of 26,490 total)