Server Configuration

Client in a workgroup with SQL Server using Windows Integrated Authentication
I have a SQL Server database server, member of a domain. We use only Windows Integrated Authentication. Now, we have some domain users that need to access our SQL Server, from workstations not joined to the domain (member of workgroups). Is it possible they access the databases using Windows domain logon credent... 1 Jul 2008 17:29

Newbie - Moving a table from one database to another
Hello, I'm very new with SQL. I wanted to find out if there was an easy way to move (or even copy) a table from one database to another database (on the same server). We are using SQL 2000. ... 3 Jul 2008 07:22

Percent of advance in Restore database
I am making a huge restore database with sql server 2000 and I need to know how to find the percent of advance of the operation. I cannot find it ... 2 Jul 2008 13:58

Proxy Credentials Frustration
Please let me know I'm not crazy. I have a NAS that I want to back up to. It has a user account, we'll call him Bob. Lets say I have a folder \\NAS\Backuphere\ which, if I'm logged into my computer as "bob" with the same password that bob has on the NAS, I can get to the share just fine. In SQL I can't backup to... 3 Jul 2008 12:31

To update a clr dll should I drop the assembly?
Hi all, I'm updating by hand a dll containing clr code for Sql 2005 stored procedures. My question is which are the steps needed to update the dll to the new compilation? The file is not locked so I can overwrite the old version with the new one, but it looks like the sql server does not understand the change... 2 Jul 2008 01:40

OpenQuery problem
Yes, it seems that openquery won't accept a variable or concatenated string. I guess to pull this off, we would have to hold our nose and execute the openquery as dynamic SQL. A hacker would love to poke around with a procedure that does this, so be sure to lock down the permissions. declare @SQL as varchar... 1 Jul 2008 11:18

Change SQL License Key
Is there a way to change a SQL Server 2005 license key without doing a reinstall? Any help would be appreciated! ... 1 Jul 2008 15:26

tempdb.dbo.##lockinfo60
I am running SQL2000. I received a notice that my drive W: was almost full. I did not know drive W: was even being used. It has a folder called SqlData which has tempdb.mdf and templog.ldf in it. Therefore we have W:\SqlData\tempdb.mdf at 1.2 GB and W:\SqlData\templog.ldf at 6.7 GB. I went to rename them ... 1 Jul 2008 15:26

i just want to take object Order FULL DB
with help SQL Management Studio i can take Script the whole DB , then i can create NewDB with help of taken script . i just want to know what type of order they r using ? ... 1 Jul 2008 10:16

Can it be solved by a Query only ?
There are 2 tables in an application system. The first table "grpmem" contains both group_id and member fields. select id, c_last_name from ctct where id = 735169 id c_last_name 735169 Property Service Officer In the second table "ctct", it contains both data for Role and Member... 1 Jul 2008 08:13