Friends,
I have the following part of my qry:
Seconds=case when ((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000)-((floor(((passingtime*.0001)-((floor((passingtime*...
Hi Experts.
I'm working two SQL server. one is Development SQL Server and other is the production SQL server. They're both SQL 2005. I'm trying to select Data from one Server Database and i...
I have successfully been connecting to an Avaya CMS database (Informix on Solaris) using the provided OpenLink ODBC driver using SQL Server Integration Services. I export some of the data to a...
Hello everybody,
yesterday I installed the SQL server 2005 SP2 on our server.
The installation failed as far as the MSSQSERVER service is concerned (all the rest was successful: reporting ...
I have added an "ActiveX Script Task" to an SSIS package. I have copied and pasted my VBScript into the task. The code parses fine, and runs independently.
When I try to "execute step" from...
I am having a problem with my sql statment and a report parameter when mutliple values are selected.
Here is my SQL Statement for the report [Dataset1]
select owneridname, regardingobjecti...
When data is entered into a table the date is automatically entered using (convert(char(8),getdate(),112)) as the default value for the date field, which displays in the format - dd/mm/yyyy.
...
I'm trying to setup a mirror in SQL 2005 using the GUI interface in SQL Studio manager...It will connect & succeed on everything during setup, but when I click on start mirroring I get the fol...
Hi,
we created a SSIS Package and now we want to run this package from SQL Agent Job. we set up the job and when we run it, it failed
Job Properties:
Type: SQL Server Integration Service...
When trying to use database mail, I get an error whenever I send test mail outside the domain of the originating address. The error is: The mail could not be sent to the recipients because of ...
I don't know if you can help me, but I'm trying to run our .net/aspx web site locally from my development machine, but I keep getting this error:
"An error has occurred while establishing a...
Hey Guys,
My Sql Server transaction Log is now 1.4 Gig and my Database size is 1.o GIG.
Is this common or can I clean up the Transaction Log?
How can I go about cleaning the Log?
I am ...
I have a stored procedure P1 which creates a temp table #tmpT1, this stored procedure P1 calls another stored proc P2, the insert in the temp table occurs in P2, when I do a select count on th...
My website was compromised today and now every time I load a page from the database, the website download a Trojan horse to the user's computers. At first I was not sure if it was the code on...
Hi All,
I'm trying to copy data from my local database to the online server, using SQL Server 2005 Management Studio. Im using the Import/Export Wizard which i have used many times before. ...
Hi,
I have one specific client database that is growing very rapidly and the LDF file is taking up more than half a TB. I have maintenance plans running differential backups from Monday to ...
Greetings Experts!
I have been trying to get a copy of the AdventureWorks Sample Database for SQL Server 2005, and I can't seem to find it anywhere, I tried on Microsoft Website and they prov...
Hello,
in a SQL Express db, I'm trying to delete rows from 3 different tables. Basically, I'd like to delete the result of the following query:
SELECT *
FROM tbPartners, tbClients, tbTr...
Hi,
How to unlock sql logins in Query Analyzer in sql 2005, I try with "alter login Zack enable", this wont work, guess this will work if account disabled, how to unlock it?
Greetings,
I am running a 3rd party application on a server that is running a data extraction from a source database to a reporting database. Both DB's are on the same server. The server is a...
I'm trying to set up a stored procedure to perform the following:
1: Perform a select query
2: Loop through results of select
3: for each result, perform a second query
4: based on result ...
Hi,
How can i see a user list which connected to sql server 2005?
i want to generate 6 digit random number in the SP ..for SQL server ..how do I generate that?
I'm trying to create a bulk insert proc but i got this error:
Invalid column name '' WITH (FIELDTERMINATOR = '\t')'.
------- this the proc----
CREATE PROC Bulk_Import
@SourceFilePath varch...
Hello,
We're running a hosted CMS system based on ASP and SQL server 2005. Now we've encountered a typical SQL injection attack, where the "hacker" tries to execute an sql query in the quer...
