Hello. How can I receive the ISO 8601 week format retrevied from a Date object of SQL? I now use : DATEADD(d, -1, DATEADD(ww, DATEDIFF(ww,0,stamptime), 0)) wo get the week of the year, by this returns the first week of the year as where 1 of the month is, also each week starts with sunday ...more >>

C:\osql -E [SQL Native Client]Named Pipes Provider: Could not open a connection to = SQL Server [2]. [SQL Native Client]Login timeout expired [SQL Native Client]An error has occurred while establishing a connection = to the server. When connecting to SQL Server 2005, this failure may be = caus...more >>

Hi All I am trying to install MDSE SP 4 for BCM V2 and get the message setup failed to configure server.This is what the confsgvr.out states An error occurred while attempting to start the service (1460) SQL Server configuration failed. I have already tried renaming the SQL folder and...more >>

I was looking at the install requirements for SQL Express. It says that the 1.2 runtime must be uninstalled to use it. Is that true that the 1.2 and 2.0 frameworks can't co-exist? Can Express be used from a 1.2 app, or must we switch to 2.0? I need to update a single user with our curr...more >>

Hi, I have subscribed to SQL Mag and in it it says any ques i can post to savvy@sqlmag.com but the problem is i have tried email my ques to them before but so far nobody has ever replied my queries(and it has been several months.) Have anyone faced this before or the above email addr i...more >>

Hi, Is there any security updates/patches for SQL Server 2000 or if there's it's actually part of the windows updates as well ? kindly advise if there's such website where i can get these updates for SQL Server 2000 tks & rdgs -- Message posted via SQLMonster.com http://www.sql...more >>

Are there ways to tell if MSDE 2000 is current and patched on a Windows 2000 SP4 server? We have scanned it with MBSA 2.0 and it doesn't say that SQL 2000 SP4 is needed (or that it's the latest SP available), and we are pretty sure it's NOT at SP4 yet. Thank for any help. ...more >>

Hi, I'm using a Recordset with UseServer and Keyset cursor. It works fine except when I ask about record count. Then my application raises this message "sp_cursorfetch: Value of parameter 'nrows2 is invalid" What can I do to solve this? ...more >>

I successfully installed MSDE, but I cannot open the application. All my files and folder are installed under: C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK. My operating system is Windows XP Professional and my Internet Explorer is version 6.0. What do I need to do? Please advice. ...more >>

Hi, I would like to know the following : 1. During replication , is the data being transmitted in binary format 2. where do i get to check the size of the whole replication(in bytes/KB) ? 3. where do i get to check the size of a single table being replicated (in bytes/KB) appreci...more >>

When I try to install MSDE 2000A, using "setup /L*v error.log SAPWD="password" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0" I not only get a log file for the msde setup, but I also get a log file in C:/Windows, setupapi.log, that starts with Executing "C:\WINDOWS\system32\setup.exe" with com...more >>

Hi! I know that the default instance of MSDE is the computer name. If the computer's name is subsequently changed, will the default instance’s name change to the new computer name as well. Thanks for your thoughts....more >>

How to make SQL Server Management Studio Express (SSMSE) CTP to start when SQL Server Books Online is also installed? SQL Server Management Studio Express CTP is starting at once when SQL Server Books Online is removed from Control Panel/Add or Remove Programs! :( I'm using the latest, tod...more >>

Hi, Is there a Reporting tools in SQL Server Standard Edition ? or it's actually refering to the Analysis Services ? tks & rdgs -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-msde/200512/1...more >>

Hello - I downloaded everything and installed MSDE (I'm running Windows 2000 Professional). I can see the instance I installed on my local C drive. When I click on the icon for Sql Server Service Manager, and click down on the arrow, there is nothing in there; there also is nothing under...more >>

I haven't installed this yet but does anyone who has have any comments on the pros and cons vs. SQL2005 Express? Also, does it have any graphical management tools (analogous to Mgt. Studio Express)? Many thanks. ...more >>