| Groups | Blog | Home |
|
March 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
sp_executeSQL Database Files. Posted by Roger at 4/28/2007 11:41:15 AM I would really appreciate if anybody can correct me in the following query.
In the following query, I am passing the database name and getting
DataFileName in to the output variable, I would appreciate if any body can
look into that and solve this problem.
declare @dbFile varchar(10...more >>
Help!... Sybase nightmare! Posted by mfc at 4/28/2007 4:24:28 AM Hope someone here can help me out.
I've worked with SqlServer for the past 10 years, unfortunately in my new
job they have a mixture of databases. One of the legacy systems I need to
support uses sybase.
The guys here use isql (console based) and gvim (a vi editor clone) to write
and tes...more >>
DataFile and Log File Posted by Rogers at 4/27/2007 4:58:36 PM I want to know the datafile and log file for the given input parameter. I am
basically creating function and the input parameter would be database name
and that will return me DataFile and the LogFile.
Can anybody tell me which query I have to used in the function. I have to
used to get the...more >>
deadlock on a single Select not in a transaction Posted by ThunderMusic at 4/27/2007 3:03:08 PM Hi,
We have a web application developped in asp.net (I think it's not relevant,
but well, it's so you know)... Yesterday, we received the following message
"Transaction (Process ID 69) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the ...more >>
How to get remote server datetime Posted by Ram at 4/27/2007 12:24:01 PM Hi All ,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?
I have a stored proc located in SQL server at CST zone where I need to
query for the current date/tim...more >>
SQL Server 2005 Standard Edition Posted by Rogers at 4/27/2007 11:05:54 AM I have SQL Server 2005 Standard Edition Service Pack 2, I want to create
Database Mirroring, how can I setup? any idea?
Thanks
...more >>
Installing SQLNCLI Posted by Greg Larsen at 4/23/2007 9:24:02 PM I would like to install the SQLNCLI on our IIS machine, and possibly other
workstations that need to connect to SQL Server 2005. Where is the correct
location to get the most update to date version of SQLNCLI? Also need the
installation instructions and considerations.
Thanks
Greg....more >>
Installing SQL Server Posted by Kramuddin at 4/22/2007 8:44:03 PM All,
i want to install a new SQL server. i have HP Proliant DL360 g4p. and i have
limited number of hot swapable hard disk drives. now my question is that can
i have one 10k and 15k server HDD working as mirror?
cheers,
kram
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Import & Export in SQL 2005 Posted by Rogers at 4/19/2007 11:41:34 AM I want to import and export data in SQL Server 2005, how can I do through in
Microsoft Sql Server Management Studio..
Thanks
...more >>
Sql client 2000 connecting to Sql Server 2005 Posted by Geoff at 4/19/2007 10:20:04 AM Is it possible to connect to a Sql Server 2005 with Sql Client 2000? We have
a piece of software that only communicates with the 2000 client but would
like to use sql server 2005.
Thanks,
Geoff....more >>
Group By Posted by Jeremy at 4/19/2007 6:40:00 AM I'm trying to aggregate values and grouping the results by defined periods (6
month, 12 month, 18 month, and lifetime). I'd like to do this with one pass,
but using a CASE statement did not aggregrate correctly. The results are
more like 6 months, 7-12 months, and 13-18 months, 19-lifetime. ...more >>
Excel to SQL Server. Posted by Roger at 4/16/2007 8:35:38 PM I would appreciate if any one can guide me or send me any stored procedure
through which I can accept the Excel file from User Interface, save it into
any physical folder or in the table and do some process and save the data
into the Database and also archive the excel file for future referenc...more >>
decimal data type serialized to binary Posted by ThunderMusic at 4/16/2007 1:29:34 PM Hi,
I have the value 1234.1234 in a decimal field, converted to binary
(cast(myField as binary(13)), it gives 0x000000000013060001883a8f49. When I
use SqlDecimal in .NET, for the same value, I get 0x883a8f49 which makes
0x1306 the precision and scale (precision 19, so 0x13 and scale 6, so 0...more >>
Backing up Database Posted by Gabe Matteson\\ at 4/13/2007 12:36:08 PM When I try to backup a SQL 2000 database I recieve the following error in
the output log. Any ideas? Thank you.
SQL 2000 w/ SP4
[39] Database SolRounder: Database Backup...
Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Erro...more >>
driver's sqlallochandle on sql_handle_env failed Posted by moharil at 4/13/2007 6:18:02 AM i have just installed sql clinet
(Microsoft SQL Enterprise Manager Microsoft Corporation Version: 8.0)
on windows XP sp2 . whenever i try to reg new sql servers through Enterprise
Mgr it gives me this error . it looks like its associated with ODBC . need to
figure out whats the problem
--
...more >>
Log Shipping.... Posted by Rogers at 4/12/2007 11:48:04 AM Log Shipping....
In my organization we had implemented Disaster Recovery (Log Shipping) but
Log File size is increasing gradually (140 GB) and Data File size is 20 GB,
I am just wondering log file size should be trancate once it will ship to
destination Server,
FYI, log ship every after ...more >>
SSIS Posted by Rogers at 4/12/2007 10:37:18 AM I would appreciate if any one send me the step by step link like how to
create SSIS package and implement this in SQL Server 2005.
Thanks
...more >>
DateTime Field, Insert a Null value. Posted by tclancey at 4/10/2007 12:00:00 AM Hi. I'm having some problems getting a Null value into an SQL DateTime
field. I'm all googled out, but I did find a bit of code using the
parameters that looked as if it might do the job, but unfortunately any
nullDate saved in the column is stored as Now. My SQL column is set to
allow nu...more >>
Can't find client Posted by Kit Wong at 4/5/2007 7:22:00 PM I can't see any SQL Management tools after installed SQL 2005. How can I see
the database by tools just like what we had in SQL 2000?...more >>
User authentication Posted by William A. J. at 4/4/2007 7:28:44 PM Hi experts!
When using SQL Server Management Studio to connecto SQL Server 2005, we are
given options to connect using Windows authentication or SQL authentication.
My question is, when using Windows authentication, how do we choose to use
other Windows accounts? The login section becomes g...more >>
Encryption and Decryption Posted by Rogers at 4/3/2007 5:23:14 PM Can anybody let me know how I can do Encryption and Decryption of data in
SQL Server 2000 Database
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |