Viewing 15 posts - 1 through 15 (of 24 total)
select srvname from master..sysservers
use this code in your frontend to populate the data in the drop down.
February 3, 2005 at 5:47 am
Hi, this is Satish Teli from India, working for a Manufacturing company called Madura Coats Ltd. I have 3year and 9 months of IT experience in the same company, over...
April 5, 2004 at 6:10 am
Login as Administrator and then try starting the services or if the Services are set to auto start then check what happens. This happens when the Authentication is mixed i...
September 25, 2003 at 2:30 am
Well, what I have abserved is that if you are trying to connect to a server which resides in another LAN, often noticed that connection via Named Pipes fails and...
September 25, 2003 at 2:26 am
Well, what I have abserved is that if you are trying to connect to a server which resides in another LAN, often noticed that connection via Named Pipes fails and...
September 25, 2003 at 2:22 am
Well, what I have abserved is that if you are trying to connect to a server which resides in another LAN, often noticed that connection via Named Pipes fails and...
September 25, 2003 at 2:22 am
Hi Frank, I'm from India-B'lore and Name is Satish(1st name), Teli(last name) is my SIR name.
cvandemaele, as far as u'r argument goes, at times just allowing the field to...
September 13, 2003 at 5:54 am
Ya, there are few constraints. You need to set the Quote Identifier on, by default it is off, which means that if u have an values within double quotes in...
September 10, 2003 at 2:46 am
Use truncate the log on checkpoints, this will keep a check on the Log's file growth. Use TruncateLogOnCheckpoint, for more info check BOL or recommended sites.
September 8, 2003 at 6:28 am
U mean to say that, both the Databases are on one server and you are able to access one and not the other? Also, just your user id has...
September 8, 2003 at 6:16 am
I guess the only simple way out would be, to take a dump of the database on to any of the external storage devices and send it across and ask...
September 8, 2003 at 6:09 am
Are you maintaining any intermediate table with DB Ids? If yes, then, try dropping and recreating it. Then it Should work.
If possible, try and post u'r code.
September 8, 2003 at 6:02 am
Take a complete backup of the database and then restore it on to the destination server...this will take care of u'r problem.
September 8, 2003 at 5:51 am
It is recommended not to use NULL in any of tables and instead update it with some default values. This case, since it is an INT
field, it is better that...
September 8, 2003 at 5:47 am
Hey Mike,
Make it simple, as the other person said, use constructed queries, thats basically, u will have to arrange the SQL statement with a string variable,let say @STR,...
August 30, 2003 at 5:10 am
Viewing 15 posts - 1 through 15 (of 24 total)