RE: How to Insert word documents into sql server?

ADO stream object is the easiest. Search www.msdn.microsoft.com for sample code. I'll put up an article on it soon, it's a common question - not a bad one either. Andy http://qa.sqlservercentral.com/columnists/awarren/

RE: Locking problem

hope you performed the sp_statistics after the restore/load in sql2000. Do you perform the "SELECT max ()" using an index ?

RE: cpu utilization

I'd say you probably need more memory. The page swapping is drive up your CPU load. Check drive IO while you're looking, it's probably high as well. All things considered, more memory never hurts and is easier to add than drive space. Andy http://qa.sqlservercentral.com/columnists/awarren/

RE: Can't start server agent.

But SQL Server Agent is a Windows service. That means it runs under the context of a Windows user account or the LocalSystem. If it's running under LocalSystem and you've removed BUILTIN\Administrators, you'll need to add [NT Authority\System] as a login and put it in the SysAdmin role. You can find what account SQL Server […]

RE: Who should manage/support Analysis Services?

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: collation prb

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Can't open EM or QA after deleting default db

Are you sure there's a separate login for Administrator ? In most cases the administrator account get's acccess through the BUILT-IN\Admins group. So you might have to change the default database for this group.

Mary is a member of a SQL Server...

RE: Remote Linked Server: SQL Server does not exist...

How are you connecting to the other server? Make sure you qualify the user with domain name\username. Also what is the security mode on the other server?

RE: Use of TempTable defined at runtime

OK - in your example it appears that you know what column1 is...for the sake of this example, we will call it VARCHAR(50) CREATE PROCEDURE myProc ( @tempTable VARCHAR(50) ) AS DECLARE @colReslt VARCHAR(50), @sql NVARCHAR(1000), @paramDef NVARCHAR(1000) SELECT @sql = N'SELECT @colReslt = Column1 FROM ' + @tempTable, @paramDef = N'@colReslt VARCHAR(50) OUTPUT' EXEC […]