| 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 |
Filter by week: 1 2 3 4 5 Lost Log File ! Posted by Joh at 5/13/2005 12:38:18 PM Here is the following stuff which I do for recovery log file ... basically I
have lost log file and I only have a .mdf file.
Before going to the DOS mode I update the status of Health Database to 32768
and I only have a .mdf file.
From the DOS mode I used the following command
sqlservr -c...more >>
General question Posted by Joh at 5/13/2005 10:12:06 AM In the the dos mode I want to search in the SQL Server binn directory like
show me all the file which start from SQL like in database we can write
select * from tablename where fldname like 'sql%' any idea in DOS how can I
search all the files start with SQL ?
Thanks
...more >>
-T3608 -T4022 Posted by Joh at 5/13/2005 10:01:27 AM sqlservr -c -T3608 -T4022.
Can any one let me know about T3608 & T4022 means ? I have failed to findout
in BOL..
Thanks
...more >>
ntwdblib.dll & sqlaiw32.dll needed for app. to run on MSDE ? Posted by THA at 5/13/2005 3:14:02 AM Hi..
We're developing an application against an SQL Server, that is the
developers have an SQL Server installed, but the end user will only have MSDE
installed and no SQL Server will be used at the end user's site.
When trying to run the generated app. on the end user machine with MSDE it ...more >>
Cannot start MSSQL Server 7 Posted by Water Cooler v2 at 5/13/2005 2:06:49 AM I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing informati...more >>
sp_attach_single_file_db Posted by Joh at 5/13/2005 12:00:00 AM I only have a MDF file not the log file and I used the following command
......
EXEC sp_attach_single_file_db @dbname = 'test',
@physname = 'C:\test_Data.MDF'
Error:
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'test'. CREATE DATABASE is aborted.
Device ac...more >>
Just to confirm Posted by Joh at 5/12/2005 4:48:33 PM I just want one confirmation like I have create one job which take daily
full backup in the night at 1:00 AM and the other job which took log back
every 1 hour, should I shrink the log before taking the full backup or after
taking the full backup I have to shrink the log file?
Thanks
...more >>
Trimming trailing white spaces Posted by Hung Le at 5/12/2005 4:14:02 PM Currently our database has Ansi_Padding turn off but we have many cols in
tables which have trailing white spaces. I need to find a set up or SQL set
command to remove all the white spaces which trailing the Varchar field type.
Please hep...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Yukon Event Posted by Joh at 5/12/2005 12:51:31 PM Can any one have any idea regarding the Yukon 2005 event in Toronto in the
near future, we want to attend the seminar...... or which microsoft support
email I can ask for that
Thanks
...more >>
EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters Posted by Sachin Surana at 5/12/2005 8:50:05 AM Hi All,
We are running a job for archiving old data. The job calls a stored
procedure. The data gets copied successfully to a different database but when
a query is run to delete the data from the source database, it does not get
completed.
What is it trying to do ? Why does it not move ...more >>
Convert mssql file Posted by Nick Mirro at 5/12/2005 6:48:34 AM I am running mssql server for a sharepoint site. I have a mssql .bak file
that needs to be converted to plain text sql queries.
Is it possible to convert it somehow?
...more >>
Confused. Posted by Joh at 5/10/2005 3:07:43 PM Still little bit confused regarding Statistics updates and rebuilding
indexes..... can any one give me one basic difference.
...more >>
Log Posted by Joh at 5/10/2005 12:04:03 PM Please correct my concept, as I am thinking when log backup it auto shrink
the file to its mininum point like when I take the log backup and see the
size it's still on the same size but yes when I shrink the log then it's
goes into minimum size so now the
point is like I do take only the log bac...more >>
Every 2 seconds hiting. Posted by Joh at 5/10/2005 8:57:53 AM I am creating one Call centre database and application. The issue is that
application will hit every 2 seconds to database for checking calls so is
there any optimized way I can use like instead of hiting the database every
2 seconds I use any alternate way ?
Thanks
...more >>
ReportingServices...add on? Posted by No one at 5/10/2005 12:00:00 AM Does anyone know if the reporting services is an add-on to the SQL
server license or does it have its own license that must be purchased?...more >>
Multilang. Posted by Joh at 5/9/2005 4:47:52 PM If I want to save the Chinese, French and English data in a single table so
the column datatype would be nvarchar right?
...more >>
Batch File. Posted by Joh at 5/9/2005 1:59:26 PM I am creating one batch file which move datafile and logfile into different
machine but I want to ask one question like if one command successfully
executed then I have to wait for 20 seconds and then execute the second
command ..... can any one know the command which I can use in batch file....
...more >>
Delete directory Posted by Joh at 5/9/2005 10:46:21 AM Can any one let me know like how can I remove one directory, which contains
couple of file, through xp_cmdshell extended stored procedure.
Thanks in advance.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |