SSIS Hello. Firstly excuse me if this doesn’t make a lot of sense as I’m fairly (as in 2 days ago) new to SSIS. Ultimately I’m looking to import all data from an XML file and depending on what kind of file it is process in a different way and load to a set of relational tables in a Microsoft SQL Server 2008. Each XML file has a Boo...
Does Sql Server management studio have no nice support for multi-monitor setups? The only way I can see to use it multi-monitor is to stretch the main window across both monitors, but this isn't really practical, as my two main monitors are different sizes and resolutions (external monitor on a laptop). I was hoping for something at ...
Hello. Before I give myself some sort of stress related heart attack. Would anyone know how to complete the seemingly simply task of setting the result set of one data flow task (the result will be either a 0 or 1) and assigning that value to a variable. I've created the variable ok. The result set comes from an XML file with mult...
In SSMS is there a way to generate a script for table creation based on the table output by a view? ...
Does no such plugin exist? So to be clear, I realize that RedGate has their own SSMS SCC app, and I realize that VSS2k5 will integrate in. I'm looking to stay with Hg as that's where my source already is, and I'ld like to find something that my team can stay consistent with on their tools. As is, I guess I'm going to have to just run ...
Using reporting services 2005. I have a set of reports that use a custom assembly for some basic calculations. It has been deployed several times in the past successfully. I am trying to install the reports and assembly on a new instance of SQL Server, and the repors work fine as far as pulling back and displaying data. The only prob...
Hello there, My machine Win7 has SQL Server 2005 and SQL Server 2008 installed. Also, Sql Server Management Studio is installed with SQL Server 2008. Now, I want to connect to SQLEXPRESS instance running currently on my machine. How do I know if i will need Management Studio 2005 or 2008 to connect to SQLEXPRESS? Just to add that I h...
I am using Access to try to get some links to tables in SQL Server 2008. I've created a user name under security in SSMS for SQL Server and I've mapped it to a user that is under the database that I need. I've also given that user a default database that I need. When I try to connect through ODBC I am not seeing the correct tables. Wha...
I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to do this graphically with SSMS? ...
I have two databases: DBTarget and DBTest. I've run several custom scripts on DBTest, so now DBTest and DBTarget should be identical in every way (Tables, Values in tables, Columns, SPROCS, etc.) Question: Is there an easy way to compare these two databases? The only strategy I can think of is: USE [DBTarget]; SELECT * FROM tblTableN...
I have two databases with THE SAME schema. I need to copy the contents of all the tables from one database into the other database. What is the best way to do this>? There are about 200 tables. I have ssms. ...
In SSMS 2008 R2 I create the table aTest(Albnian varchar(10), Dflt varchar(10)) In SSMS table designer both column properties have Collation: < database default > (under Column Properties--> "Table designer") I change collation of column Albnian to a non-default, for ex., to Albanian_CI_AS. If I script the table in SSMS (right-cli...
I create 2 tables and another 1 with foreign keys to the other two. I realized I want to make some changes to table no 3. I try to update a field but I get an error "Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created." I delete those 2 relationships but when I look at d...
Possible Duplicate: SQL CASE statement Hi Frdz, i have created a stored proc and i put three queries in stored proc with inputvariable @EtlLoadId = 0 and i get three different windows for each query under result tab. is there any chance i can get results from the stored proc (results of three queries) as only one window and r...