Viewing 15 posts - 2,881 through 2,895 (of 3,221 total)
In the upper right hand corner of this page is a box labeled SEARCH enter the words "Best practices" click on go.. in the resulting window select "Articles" there you...
September 8, 2008 at 3:08 pm
For a complete explanation see:
Microsoft's recommended method to get around the problem:
http://support.microsoft.com/kb/194124/EN-US/
You can add the option IMEX=1; to the Excel connect string in the OpenDatabase method. For example: ...
September 8, 2008 at 2:42 pm
Think when Lynn says:
Not having the DDL or sample data for the tables, I don't have the enough to work with to see what could be done.
she means what is...
September 8, 2008 at 2:34 pm
Maqsood from:
From: http://blogs.msdn.com/psssql/archive/2008/04/21/how-it-works-what-is-a-sleeping-awaiting-command-session.aspx
This issue is as old as SQL Server. In fact, it goes back to Sybase days but continues to fool and puzzle administrators.
A session with that...
September 7, 2008 at 5:16 pm
Check "C:\Program Files\Microsoft SQL Server\80\Tools\Books\adosql.chm" - part of a complete install of SQL 2000, and a fantastic resource for using ADO to communicate with SQL Server.
adosql.chm is a...
September 7, 2008 at 2:19 pm
IMO it is best to switch the approle immediate after the connect.
ALZDBA - that is exactly the flow specified in my posting.
This way you'll not forget to...
September 7, 2008 at 2:00 pm
First of all go back until 2 days ago and reread my posting.
You do NOT assign yourself to the 'donuttin role - keep your current role which I assume is...
September 7, 2008 at 12:50 pm
For your work station at home -- go to Amazon.com and look at the DEVELOPER Edition of either SQL Server 2005 - cost $45.00 USD, or SQL Server 2008 cost...
September 6, 2008 at 12:54 pm
Jacob Pressures download Books On Line from:
September 5, 2008 at 9:12 am
rbarryyourg
and then assign each of these users to a role. I would call the role "Donuttin".
I meant to set the users to the Donuttin role which is a database...
September 5, 2008 at 9:04 am
The application role and control of same has changed from 2000 in 2005.
Reading from BOL it would appear that you set up logins for each user of the application, and...
September 5, 2008 at 7:02 am
Here is a method I have used. It should be noted that each stored procedure to be logged will have to be modified to include:
EXEC Dbo.PerformanceStats_Update @@Procid
Use...
September 4, 2008 at 12:21 pm
Does not work
SELECT * FROM information_schema.routines r
WHERE charindex('Dbo.People2', r.ROUTINE_DEFINITION)>0
Does work
SELECT * FROM information_schema.routines r
WHERE charindex('People2', r.ROUTINE_DEFINITION)>0
Nate Schmidt
fully qualified my tables ([database].[schema].[tablename], I suppose putting a period in...
September 4, 2008 at 8:47 am
or is a better route to install free SQL Express on their desktop, so they can manage their database that way.
.
Carefully check SQL Express SSMS it is lacking a great...
September 3, 2008 at 2:39 pm
Maryjane in the "Chose Data Source" window what do you select. For example if you chose "SQL Server Native Client 10.0", the next window will have a command bar...
September 3, 2008 at 9:44 am
Viewing 15 posts - 2,881 through 2,895 (of 3,221 total)