Hello, I am a newbie when it comes to SQL 2005. I have just installed it using the following how to link:
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1235662,00.html
M...
For SQL Server, let's say I have a small enumeration of four colors... I've been doing this:
varchar(6) storing "red", "green", etc., in two tables.
I've indexed the varchar columns in b...
I want to count entries for 3 differant amounts that I use the following code to give me the differance between 2 dates.
DATEDIFF(mi, dbo.ONSA_NSS.datesent, dbo.ONSA_NSS.accepteddate) / 60 ...
Hi,
Can someone tell me what is the diff between these 2 ( T-sql ) I did try to do revoke however it did not really drop the user permission but when I do deny it does drop the permission, wh...
I'm trying to run a .NET Dll under SQL Server 2005.
I work fine but the DLL is running under the LocalSYSTEM account.
My DLL is accessing the network data
It work only if I change the acco...
I have the following data:
status item cost
4 Fee1 $25
8 Fee2 $50
16 ...
I have already installed SQL Server 2005 and SQL Server 2005 SP2. Now I am trying to install the SQL Management Tools using the media of SQL Server 2005 and get this error...
A component t...
Hi
I am new to report builder just started working with it. The report model and reports created. The model has certain datafields(entities) which donot have self explainatory meanings. I ...
I cant connect to my database using sql authentication in MSSMSE. i have sql express2005
i set up a login and typed in a login and password for sql authentication under security
i get s...
Greetings,
I have the following query which I use to obtain a particular asset UID:
DECLARE @Result VARCHAR(1024)
DECLARE @Code VARCHAR(128)
DECLARE @AssetUID UNIQUEI...
I'm looking for documentation as to install and configure database mail for SQL 2005.
Basically, I'm reading a working table and loading those values into a production table ; one of the columns is a clear password which I "hash" with something like this:
HashBytes('MD5',...
Hi,
We have a HP DL140 Intel Xeon 2.4 Ghz with 2GB RAM
We currently have an instance of SQL Server 2005 running our accounting application on it.
We recently purchased a HR software, bu...
Is there possible to do this result with a single sql syntax? How? Which means without a recordset/dataset
Data...
ID Name Group
1 Name6 Group3
2 Name5 Grou...
I have a cursur script attached and it seems to have been working perfectly. I noticed yesterday that it did not send out a email like it should have to one of the customers because one of th...
Hello all,
I am currently trying to setup replication over https (Replication Transact-SQL) in SQL 2005. Everything goes smooth, up until I run the last stored procedure. I am running the...
I am about to install Microsoft SQL Server 2005 Enterprise. Do I need to create a specific Domain Service Account to install this under or can my credentials as a Domain Admin work fine witho...
have a table with the fields of MFG, PartNumber, Description, Cost and Retail.
I have data in the table and have an excel spreadsheet with the same columns what is the best way to update the ...
Calling SQL gurus cause i am not. I have 3 tables (customer, location, customer_location). I need to write a query that will pull data from customer (name, address etc..) joined with data from...
I can't seem to think of a way to archive (move out of active database, but keep for reference purposes) old data,
The closest analogy I have is a hotel where people arrive, stay for some ...
I'm using SSIS Flat File source data item. (The data goes to a Script Component which null's dates if need be - ultimately being loaded into a SQL Table.)
The last record from the flat fil...
Hi,
I am guessing this is permission related but I am not sure. I have a db diagram in my sql 2005 database. I can open the diagrams folder and see it. Another user has access to the dat...
Hello,
I have a query that is poorly designed, running in a legacy system that I am not impressed with. The query is generated by a reporting tool. Recently the performance of this report h...
First, there currently is no DBA, just this lowly Systems Admin and I'm not very familiar with this environment. Telling the story because some of you will probably get a good laugh ;)
I h...
Hi Experts,
We have an IMClient that communicates with the product server and sends status messages to the users like job completion message and jonb transfer message. The IMClient is part of...
