Scripting Alias in Configuration Manager
Tue, 4 Mar 2008 13:08:02 -0800
Is there a way to script an Alias in Configuration Manager on the client
machines. I do not want to go to each client and point and click. I would
like to make the Alias with a script. I am using SQL 2000 and 20005 64 bit.
Clients are using XP Pro latest Service packs and patches as of 03/03/2008.
--
...
|
Problem with Named Pipes
Tue, 4 Mar 2008 01:10:00 -0800
We have enabled named pipes on a SQL 2005 SP2 instance. However older clients
running W2KSP4 MDAC 2.53 seems to be unable to connect to the server using
named pipes. Clients running 2.8 can connect. Is this a known issue!? Is
there a workaround that can be applied on the server? Do we need to open
something ...
|
test - please ignore
Sun, 2 Mar 2008 20:32:29 -0500
...
|
Using SQLCMD to test Connection
Sun, 2 Mar 2008 17:20:00 -0800
I am using the following comand to test a SQL 2005 connection, but I seem to
have the syntax incorrect.
SQLCMD -Stcp:ServerName,1433 -E
What am I doing wrong?
Thanks,
Rubens ...
|
Extract Temp table script from SMS
Thu, 28 Feb 2008 12:28:02 -0800
I have a developer request to extract script of the temp table that he
created in tempdb through SMS how would we do that
If I have created the temp tableâ?¦
SELECT â??Usernae'[Name], 32 [Age]
INTO #DELETE_ME
How can I generate a list of the columns in table #DELETE_ME
Typically I use Management Stu ...
|
problem with connecting to sql server via a wireless application
Tue, 26 Feb 2008 13:46:02 -0800
Hi,
I have created a SQL Server 2005 database in VS 2005 and I am using windows
mobile to access directly to SQL Server.
I use Vista and Windows Mobile device centre for the connection between the
device and the PC.
I have enabled remote connections for TCP/IP and named pipes. I have also
checked the firew ...
|
SQL CODE
Tue, 26 Feb 2008 16:18:10 +0100
Hi
I am kind of new at coding, i dont know if any of you guys can help. I got a
webpage with an access table and right now everytime someone visits the page
it adds the IP of the person that is visiting the page and the date but
right now i got to many of the same ips how can i stop it from adding IPs
tha ...
|
|
|
Strange SELECT statement
Mon, 25 Feb 2008 10:11:30 -0500
Hello Everyone...
I have a particular Select statement to do... for example I want a Select
like this:
Select Name, SpecialNo from emp... etc. and get result like this:
Name SpecialNo
Peter 5
John 10
Daniel 15
Bob 20
But the problem is this, I need SpecialNo to be a generated ...
|
How can you connect to SQL 2005 with Windows authentication, but different credentials than your current login?
Sun, 24 Feb 2008 17:35:14 -0500
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting ...
|
Online Trading.
Fri, 22 Feb 2008 11:35:30 -0500
Dear Professionals,
I am pretty much concern about locking and deadlocking transaction and I am
working on Trading enviornment so I have to more consious about writting
stored procedures and make sure transaction doesn't get lock things like
that. Anyone can help me out any website through which I can have ...
|
