Thank you one and all. I was a little leary about changing the DB owner to another Domain Account - even one that is a member of the local admin group and one that starts the Services. I kinda walked into a mess here and I have Databases 'owned' by 3 or 4 people that […]
I understand that normally you should let your database activity determine the size of your log file ( assuming regular backups are happening ), rather than manually shrinking it's size on disk. However what about when DBCC SQLPERF(LOGSPACE) shows that the log really only needs a fraction of the disk space it is using? ( […]
Thanks Andy A couple here. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=153039#bm153082 http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=152271#bm152956 A couple of other limbo posts have been answered since I wrote my comment. It might just be the Christmas break, but you know how it is when you take the time to answer something, only to hear nothing and wonder whether the poster has even read it...
Sorry, I'm not that much into VB anymore, but after reading your link, have you tried adVarLongBinary? But I think there are MS hosted newsgroups about VB and databases. Maybe worth a try to find a workaround if you don't want to change your app logic.
When I say this :CREATE VIEW A AS SELECT NAME, NO,ADDRESS ,DESCRIPTION FROM TEST WHERE IS_TRUE='F' ORDER BY NAME I get the message as below :The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified. If i use Top n, I have to specify the n […]
A few questions. Do you want to have all users have the same permission?If that is the case, you can just make NT Group from AD and add that NT group into SQL server.If you really really want to do, I think other people have better idea but my approch would be,1. import csv file […]
Hi,Is there any equivalent of MS Access FIRST() function in SQL Server 2000?I am looking for a workaround of FIRST function in SQL Server. Please help me out.Bye,Kamalanathan T.