Bye! I have a cluster sql. Today when i have opened the computer management i have this error: "mmc: snap-in failed to initialize. Name: H.323 Gatekeeper Manager Extension. CLSID ... " and "SQL Server Enterprise Manager - connection to application object failed. Ensure that no program modu...more >>

I am an experienced developer and would like to write an extended stored procedure (ESP) in C/C++. I know that this technology is not supported beyond SQL Server 2005 but I still need a solution that will work on 2000 and 2005. This ESP needs to access a table on the SQL Server that is it runn...more >>

Is there a way to get some hint about what sql is running for a given entry in sysprocessess for an SQL2000 PRE SP3 system? I seem to recall that I used to do it but can't find how I did it. Perhaps I really did not do it. Thanks Tom...more >>

I know that I can determine the identity value of a table using IDENT_CURRENT('table_name') but if the table is new the IDENT_CURRENT is misleading (http://support.microsoft.com/default.aspx?scid=kb;en-us;835188). Is there a way to determine if the table is new or if the identity value has re...more >>

I recently downloaded SQL Server 2005 Express Edition while downloading Visual Web Developer 2005 Express. The installation went of smoothly but strangely, unlike SQL Server 7 & SQL Server 2000, I don't find any UI like "Enterprise Manager" where one can create new databases, tables, stored proc...more >>

Hi Folks I ran the tool SQLDiag.EXE, it gave me the output which was very informative. I believe it internally runs lots of commands to generate the final output file. Is there anyway we can run only limited commands (the out that will get generated which I will be interested in) Thanks ...more >>

Hi All Does anyone know if I can run the "Best Practice Analyzer" (tool from Microsoft) using command line utility? If so, does it result any log file? Thanks PP ...more >>

Hi, I have 3 problems regarding SQL Server 2005... 1) I would like to create a SQL Server 2005 database with a T-SQL Query. I have found an example in the MSDN library to create a SQLMobile database: CREATE DATABASE SQLMobile GO USE SQLMobile GO CREATE TABLE MembershipData (MemberID IN...more >>

I have a very strange problem, it only happen to one SQL Server, other SQL Server seems to be fine I got the following error when trying to run a sp against one of the SQL Server: SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET ...more >>

Hi, I'm making a translation thingie, that contains several languages. One of them is Danish and in one of my update scripts, I've come upon something strange. I have a text containing the letter "å" which is a special Danish letter (along with ø and æ). When I create the data base and ins...more >>

i've taken over a web app built by another developer. he was stripping out special characters and replacing with standard ones when searching our people table. for instance: "é" was replaced with "e". this seemed to work fine and would return names like 'Jose' as well as 'José'. as a matte...more >>

Hi: I have a database table I have designed with a row size of 0.35 KB. Is it possible to calculate the approximate log file size (or at least the portion attributable to this table) if I know the amount of rows I will be inserting into this table every day? (a one time insert nightly) Than...more >>

Hi all, anyone know how can I get the name of the only columns used in clause from? ex: ---------------------------- create view web_1_Pagine as select tl.id as idtipologico, p.idpagina from WEB_Pagine p left join WEB_REL_PagineLocTL ip on (p.idpagina=ip.idpagi...more >>

Hi, first welcome to all of you Here I have a Query that 1) My Sql Server 2000 is running slow from last two days. I want to know what should I do to make it fast or run it like previous ...more >>

I trying to use scptxfr.exe instead of Enterprise Manager to script databases. Here is what I have: MS SQL Server 2000 SP 4 Developer Edition and MS SQL Server Enterprise Edition Here is the code I am trying to use master..xp_cmdshell '"C:\Program Files\Microsoft SQL Server\MSSQL\Upgr...more >>

Hi there gurus, can you please add your 2 cents on this design? We're having trouble relating these tables in a diagram because of the keys. Is it necesary to have the references setup? I would assume yes so the forign keys can be setup. If you look at this link, you'll see our diagram. In ...more >>

I want to know that how to take a BACKUP of a Table in Sql Server.If any one can help me with this issue. Thanks ...more >>

I have an SQL 2000 database that is backed up every evening with enterprise manager. I need to be able to restore the database to a separate machine running Windows 2003 Web Server Edition, for client access to that data. I have installed SQL 2005 Server Management Studio on the Webserver , howe...more >>

What's the downside to using SQL 2005 WG Edition as compared to SQL STD Editon ? I can live with the memory constraint and the lack of OLAP ... actually I think my main concerns are about what I might not be able to do with Reporting Services ... Thanks in advance for any comments ... ...more >>

Hi and TIA! I have an ASP.Net(VB) site that maintains parts for the military. They have requested the ability to click a button on my site which will let them upload a text file containing 100 or more part numbers. I will then place them in an SQL temp table. I will then run a procedure th...more >>

http://sikander.shackspace.com/mssql_enterprise_manager.avi i want to be able to edit each cell as i move down the rows. you'll see that when i press the down array the cursor moves one row down BUT it has the cell contents selected. for me to append anything to the contents of that cell i hav...more >>

I'm trying to write a stored procedure that will use data within a table to create the whereclause of the select statement. I have it working through an access form and it does everything I want it to, with the sole exception that it doesn't run more the once. Here's a snip of the code: DEC...more >>

(I've done a bit of research on the web to try to track down an answer to this, but I have not managed to find anything conclusive on the subject. Perhaps I'm not selecting the right search terms.) For the system my development shop is currently working on, one of the database entities can ha...more >>

I am trying to convert xs:datatime into sqldatetime select cast ('2004-11-06T12:43:17.000+09:00' as datetime) I got the following error Conversion failed when converting datetime from character string. Please advice. Thanks in advance. John ...more >>

I have Visual Studio 2005 Pro. I installed SQL Express 2005 and rebooted. But, when I right click on "Data Connections" in the Server Explorer and choose "Create New SQL Server Database..." and attempt to create a new database on the local PC, I get the following error "An error has occurred ...more >>