Thanks to everyone for that. In fact my requirement is much simpler since no one can access the database directly and can only use the routines available to them in the interface program ColdFusion. So I know that this table must exist, that the column is not the Primary Key and that it has no […]
2005-02-15
Thanks for the reply... This is still giving a 500<% var to = Server.CreateObject("ADODB.Recordset"); to.ActiveConnection = MM_s4r_STRING; to.Source = "SELECT newdate, news FROM dbo.news"; to.CursorType = 0; to.CursorLocation = 2; to.LockType = 1; to.Open(); var to_numRows = 0; %><% Response.Write "&news=" & Server.URLEncode(to.Fields.Item("news").Value) Response.Write "&newdate=" & Server.URLEncode(to.Fields.Item("newdate").Value) %><% to.Close(); %> No visual error but server logs […]
2005-02-14
Plese, verify the data format before convert.You can explicit the format for data in convert clause.
2005-02-14
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=161176
2005-02-12
You can specify the authentication mode to Windows or Mixed. When you set to mixed, you can log in with your SQL or Windows id. By default, the BUITIN\Administrators group has access to SQL Server. This group is the Administrators group on your server. This is how your admins gets access to SQL server
2005-02-12
After having been in the Oracle world for the past four years, I'm just getting started with SqlServer and have a general question for the SqlServer DBA crowd: What toolkits, home written or vendor supplied, do you use as a general purpose monitoring suite? The types of things that I'm talking span a variety of […]
2005-02-11
1 reads
If I understand your question, not being able to change the logical filename in the restore won't be a problem. Give the database a new name, and new names for the physical files, and restore the database. Once the database is restored, you can change the logical filenames with an ALTER DATABASE statement. It doesn't hurt […]
2005-02-10
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/kKellenberger/accesstosqlservertheupsizingwizard.asp
2005-02-10
15 reads
That's more like it That sounds like it will work, the only thing I'm concerned about is performance because we could be talking about many thousands of rows. What I may suggest is that we only generate the rankings every x hours which would reduce the load on the servers. Thanks again.
2005-02-08
Sorry, I don't have a solution but I can confirm that this should not happen I ran merge replication over ISDN line myself with much more updates and I've never had these problems. One question: How are your mergen agents scheduled ? Do they run continously or once every couple of minutes. You might try to […]
2005-02-08
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers