Hi I need to access my SQL server remotely. My plan is to assign a public IP to the server. In the SQL server colum the user will give the public IP...
Hi I am using sql server A on one end and SQL server B on another end. These servers on in different countries. These servers are connected through a...
Can anybody tell me where can i get all DBA questions (General and advanced) on the net? Thanks
My fillfactor reached 100% at the time of backup. I am taking full backup. Unfortunately I dont have any space in my HD also. What shoud I do?
I did that. The problem in this is I am getting an error message saying "cannot insert explicit value for identity column in a table<tablename> when...
How can I create a numeric field in a table that automatically increments? i.e as soon as i run the application my serial no. field should be...
I have developmed a software using sql as the database. I made setup file also. This was developed in vb.net. Now my question is I have given the...
I am trying to run sql command using osql. I have created test.sql file using my notepad. The files contains "USE pubs GO SELECT * FROM authors...
Hi Adriaan We ar not on the same network. I have assigned a public ip. They can able to ping my machine ip address. But if they try to connect using...
I just want to see the contents of the databse using my query analyser. I have my server at my office location. How do I access another server which...
How to connect 2 sql servers which are in different locations? Both these sql servers having internet connection. Is it possible? I know the database...
I want to make a sql query as exe file. If the users click on the icon, my sql query will be exeucted and the result can be stored in a excel or text...
Hi Ranjitjain The query will work if i have primary and foreign keys. But in my case there are not primary/foreign keys. The employee nos can be...
HiAdriaan I have tried. But still those nos starting with 44 are coming.
Hi I have two tables. One is master and another is transactiontable. I n my master table I have around 500 records with 'employee No' and other...
I have a sql table contaiing the phone nos. I want dont want to display the phone nos. starting with 1 and 44. I have given a command "select * from...
I have installed sql on f: drive on my FTP server.I can acess this FTP server machine from my network with a given ip address for some other ftp...
I am using SQL2000. I want to copy the entire database to another machine which is not connected to LAN. This will be on another location. How do I...
What is the difference between stored procedure and views? Which is faster? why? Thanks Krish
How to assign a variable which will accept more than 8,000 characters(I need unlimited) with varcar function. It should take exact space though the...
Separate names with a comma.
