insert data like 12/4/2000 12:30 AM But select gives "12/4/2000 12:30:00 AM" .We dont need that 00 (second's field) .What is the issue here.any idea...
Hello Guys,after a short break I am back(Hmm with some issues in hand [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] )<br /><br />I got...
Hi, my select @@version gives ... Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft...
Hi is there any ways to find out when Windows BOX is restarted ? Other than checking SQL error log . Will it mark anywhere in event viewer ?
Hi, is there any place where SQL agent shutdown time is logged ? Somhow my my agent service stopped , even it has 'auto start at system startup'...
http://support.microsoft.com/?kbid=902388 is my issue and i cant install sp4 as my appli: vendor wont accept sp4. I have excluded that database...
Hi, If i have SQL and AGENT Mail configured on SQL server, which one it wil use as default while sending mail to an operator ? Is there any setting...
Hi, I have seen SQL Backtrack installed with Oracle.Any here using same with MS SQL server ?Whats your opinion about the product ?And is it only for...
Hi all, I am planing for Mail config on SQL server.Unfortunatly our client dont have Exchange server.We use LOTUS for our mail communications . Has...
Hi, i have a requirement in my project . we have five collector servers(it is an appli collecting data) collecting data from a main server in an...
Can someone explain following in the view of SQL server. Weak user? min pass length in SQL server? pass expiration in SQL server and interval? pass...
Hi admins, Instead of having a 'subsribe this topic' link,it would be good to have 'subscribe this topic' check box near to message box.So reply...
Hi, i am now facing a pbm with log space. My log size is 6GB(max size also 6GB ) .I have a log backup at each 3 hrs.but user reports he is getting...
All, I want to see all backups available for a database on my server.Do you have any script available to get info like this. DB...
Hi. I wonder why no: of post is not reflecting v soon to our profile .For me wht i observed is that after a couple of post only its getting updated...
Hi all, here is an issue m facing now. Log size:15.5GB -->3.00AM : there is a log backup. There is no activity after that , as its sunday -->15.00...
Hi i have a table already having couple of records .is it possible to add one more column to the table alter table tbl_emp add (rollno int) is giving...
I have my optimization job failed with following errors . Optimization job failed ERROR-- [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC...
Hi , Is it possibe to implement replication,clustering,standbyserver or any of them in a workgroup environment ? or it require both server S1 and S2...
Hi , I have all my jobs created with Maintenance plan.I forgot to include one database for T-log backup.Is there any way to edit M-Plan to include...
Separate names with a comma.
