RE: log file is bigger than data file!!
the recovery mode is set to full, and i do log back up as well but still it stays the same all the time now!!Thanks
2005-01-07
Aggregates
RE: Logins
i did the same and works fine for me ... strange thing, may be something is wrog in the second computer, try in a third computer
2004-11-30
RE: xSQL: User Experiences ?
Hi,plaese try "SQL server compare" ( freeware ) .. just 1Mb and very user friendly.GKramer
2004-11-10
SQLSTATE 01000 Message?
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-10-11
SQL Server database know how
I am developing a stand alone application, but I want to convert my MS Access database into a SQL Server database. I want to do this to enable my application with future server needs. I have few queries about SQL Server: 1) Which version of SQL Server should I use, 7 or 2000? 2) Since […]
2004-09-27
3 reads
RE: Incorrect rowcount when viewing table properties
A rowcount can be done in two ways:Most accurate and slowest: SELECT COUNT(*) FROM MyTABLELess accurate but instant: SELECT ROWCNT FROM Sysindexes WHERE ID = ObjectID('MyTable') AND Name = 'MyTable'That rowcount is used by EM and is kept uptodate with the 'Auto Update Stats' setting for the database. But sometimes it's out of sync. So you need to […]
2004-09-10
RE: Stored procedure Returning XML String
It's ok now, I have it working, The Order By was breaking the SP. Thanks for the helpDave
2004-09-10
RE: Case Insensitive
Hi Thanks for Replyselect * from yourtable where yourcolumn collate sql_latin1_general_cp1_ci_as = 'columnvalue'i run the above query i get the following errorIncorrect syntax near 'collate' Prakash
2004-08-05
RE: SQL server doesnot exists or access denied
Thanks for replyingI am using connection string as "server=Tushar\NetSDK;Integrated Security=true; database=pubs"I even tried creating a user and accessing it. But it failed.I installed MSDE from .NET framework samples.
2004-06-21
RE: OPENQUERY Performance Issues
You will only be able to use dynamic sql to use that method (which for your needs will be the best). I suggest looking at the data on the other end to see if you access the AS400 directly on it's own client that ikt doesn't take roughly the same time.
2004-06-14
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers