Forum Replies Created
Viewing 15 posts - 2,761 through 2,775 (of 13,460 total)
-
RE: Rename SQL Server not working
you cannot rename an instance.
that means, for example, if you installed machinename\SQLEXPRESS, and you want to rename it to be machinename\SQL2008R2 that is not possible. you have to backup whatever...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Rename SQL Server not working
renaming a server is a two part process;
one occurs at the operating system; the second is for convenience in SQl server.
You rename the server and then reboot.
AFTER that has occurred,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Stored Procedure System Definition
scripting from the GUI, whether create or alter, will contain the same definition, but the GUI adds
this like SET ANSI_NULLS ON and other settings; potentially the USE [database] statement as...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Composite Primary Key Help...Query
well answers to questions for an Ingres database will hopefully conform closely with TSQL answers you get here.
the question is not really clear to me; when you run your max...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to Read tables from Inserted table (trigger)
Minnu (12/17/2013)
Hi,Thank you for Speedy response.
my question is, when i print the values from trigger
print @id
print @name
Print '--'
am getting
1
D
--
but as per my table id's 1 and 2 are updting,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: unknown user has rights in the db's
i'm thinking that your user is in a windows group that grants them permissions you didn't expect.
this query seems to get all the individual mappings for all the groups i...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to Read tables from Inserted table (trigger)
yeah syntax is important here;
you already identified that you know the a trigger should refer to the virtual inserted or deleted tables;
the key is that the original table needs to...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Is RDP Access Needed for a SQL Server Administrator?
defyant_2004 (12/16/2013)
We really want to protect the server and limit the amount of unnecessary access. Although I am not an expert at DBA work, I have used SSMS in...Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SQL Server Express Does Not Provide A Way to Setup Maintenance Plans
defyant_2004 (12/16/2013)
We just installed a couple of SQL Server Express editions with a few standard databases.Our DBAs are insisting that SQL Server Express does NOT provide the necessary tools to...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Is RDP Access Needed for a SQL Server Administrator?
As a DBA, the #1 reason (for me) I seem to need access to the server itself are for diagnosing ETL issues and managing of SSIS packages;
we have a...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Need help on improving a where clause, thanks.
I think you'd just extend the WHERE statements in the query to also compare the @RoleId :
how about this?
and g.ID in(Select ID From Groups
...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: DatabaseMail
5.5.1 implies you did not set up your db mail to send the basic authentication to have the username and password:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Convert Columns to Row in SQL
jeganbenitto.francis (12/16/2013)
Can Anyone please help me in below requirementi have a row as below
1 AAAA BBBB CCCC DDDD EEEE FFFF GGGG HHHH
I...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Login failure for user 'NT AUTHORITY\ANONYMOUS LOGON'
whoops i cross posted from anotehr post;
can you show us /script out your linked server?
that would help us diagnose the issue for you.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Login failure for user 'NT AUTHORITY\ANONYMOUS LOGON'
look at the stored procedure in question...i'd bet it is referencing a linked server. the login is failing at the linked server because whoever is calling it doesn't have mapped...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 2,761 through 2,775 (of 13,460 total)