Hi All: I'm missing a basic concept in SQL2005 Security.
I have a dB on a staging server set up like:
dBname: someDBname
login: someDBname --mapped as dbo

I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
VBScript
From a remote location I connect to the server and grab those info with my
administrative rights, but I'm not accessing the DB with a SA account...

Question, I just came from an ms sql 2000 enviroment to the new 2005
sql server management studio. In 2000 enterprise manager, if I wanted
to update some data quickly, I could expand the database tree on the
left side of the app... right click on any table and select "Open as

I really don't like the new SQL Server 2005 Management Studio.  I much
preferred the old SQL Server 2000 Enterprise Manager and Query Analyser.
The thing I hate most about Management Studio is this behavior: If I select
File/Open/File and then select a SQL script file to open, the ...

I was working originally with what turned out to be a very unreliable
offshore IT firm in India. I had to finally severe our working relationship
with them. The were about 70% complete even though that demanded 100%
payment upfront. My problem is they site me all the site files ...

In the Notifications section of SQL Server Agent > Jobs, only one Net
send operator can be selected.  Setting up an operator with multiple
semicolon delimited computer names as recommended in the following
thread did not work:

Could i please ask your advise about how i best document my databases.
I have a need to provide handover documentation of my database schemas and
also of my intergration services packages.
What do you guys currently do? I have seen a number of products that

While in SQL Server Management Studio I right clicked and selected
Design Query in Editor ...
I am able to design a query in Query Designer, but I cannot Execute SQL, it
is ghosted out and I can't select it.

I have two separate servers with SQL 2000 installed. Simple install and no
replication.
Server A is production and is running SQL Server 2000 Standard Edition
Server B is development and is running SQL Server 2000 Standard Edition

Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank.  I can leave it
open all day long and it will never check/"poll"/what-have-you the server to see what the status is.  It will only check when I
click on the server ...

I need to generate a load of test data for an upcoming project and came
across the DBGen tool in the SQl 2000 resource kit. I'm wondering if there's
a new version in the 2005 resource kit? If not, will the 2000 version work ok
in sql 2005?

I am trying to load the 30 records into the database table. I have created
one Format File and one .sql file to load the data. I observed one problem
during loading the data into table, if there is any problem in the first
record of my 30 records, the sqlcmd is rejecting the ...

We have quite a few SQL 2000 servers and 1 2005 Server can I use the
Enterprise Manager from 2005 to manage the 2000 servers?
Thanks

Hi, I have a table with 22 million records in a sql 7 server. I want  to copy
it to a SQL 2005 database.
What is the most quickest tool to use (BCP, Bulk insert, SSIS) and how.
Thanks in advance

Under what conditions is 'Change Type' available? I used to use it a lot
with EM2000. If I choose 'Open Table' in Object Explorer then 'Change Type'
dropdown is grayed out.