I am really new to SSIS and struggling. I have to create a text file apending the output of several queries. How do I use SSIS to create this text...
We want to set up mirroring. We are using Standard SQL Server 2005. Where is the best web page or book to learn about how to do it?
When is the next version of SQL Server coming out? I was thinking it was going to be 2011 but then SQL Server 2008 R2 came out (SQL Server 2010). So...
I have learned that they are changing the port number for the JAVA programmers.
This web site helped: http://social.msdn.microsoft.com/Forums/en/transactsql/thread/08f65989-fb96-4c0c-9ed9-d7d6329c10d6 Here is an example of what...
I have my code coded as "EXEC master.dbo.xp_cmdshell @cmdline". If I had it coded as "EXEC @returncode = master.dbo.xp_cmdshell @cmdline,...
I have a JAVA developer asking me this question. I am not sure how to answer him. I am not sure I understand his question. He is using JAVA to...
We have a SQL Server 2005 default instance set up on a server. I was requested to install a named instance and to use a static port number. What is...
rs.exe is what I was looking for.
Reporting Services is absolutely new to me. I have been requested to followed the steps in this blog...
I have learned that to execute a SSIS package from a procedure you can use the following code: dtexec /SQL "PackageName" /Decrypt "abcde"' In...
SQL Server 2005
Today I set up Snapshot Replication to replicate some tables from production to development. Then another individual went to rename one of the...
If I create a SQL Server user on the Publisher must that user have sysadmin privileges? It looks like it will work if the user is set up as db_owner...
I have set up Snapshot Replication from one server to another and I believe that I have set it up correctly. However, I am getting the following...
I learned that using a common table expression would help in my case.
So this is an example of my code that I reuse over in the select statement. I do not believe that I can create a view with it....
I have a very large select statement. I was hoping to somehow take out the repeated code that is used and store it somewhere and access it through...
This was what I was looking for and I found it... CREATE FUNCTION dbo.udf_Lookup ( @Label VARCHAR(50) --code to return ) Returns VARCHAR(50) AS...
Here is an example of my table. LBound and UBound are numeric where Label is a varchar. LBound UBound Label 0.00 0.25 <.25 0.25 0.50 .25 to .5 0.50...
Separate names with a comma.
