This is a repost of a question I asked 4 or 5 days ago, with zero response. Hoping for more luck this time... (Using SQL Server 2008) Hi Within the next few weeks I plan to introduce SQL server to an office that is in dire need of a proper data server. Currently there is a heavy reliance on loose Excel and Access file (supplemented wi...
I would like to offload the work of generating an sql statement from the application to the database. Is this possible? ...
Is there a way to change the window title of my SQL Server Management Studio to display current server I'm connected to? To know which DB I'm connected to, I have to scroll all the way up to see the name of the server and it's a pain.. Maybe there's an available plug-in or something. ...
Is there a tool that allows me to create a sql populate script for a table using its current data? ...
Is there a way to set an "Select Only" Mode? I work with SQL Server Management Studio and im afraid of editing some lines while selecting stuff from the database! ...
My program allows users to view and edit their data online, and admins to download from/upload to my database from their desktop application. Problem is that while an admin is downloading/updating, and for a while after (could be a minute, could be 30 minutes), I can't open SQL Management Studio on the server. Sometimes it won't let me...
On a per-object basis, SQL Server Management Studio has the option to script the object to clipboard, file, etc. Is there a way (at the database level) to do a "1-click" export of ddl AND data to a text file? Ideally I'd like to select a database and create a big text file containing the ddl for all objects plus the data in all tables....
Question: when I create a table (T_TableName) using SQL Server Management-Studio, it always creates the table as Domain\UserName.T_TableName instead of dbo.T_TableName What's wrong ? ...
Our Sys Admin just installed SSRS 2008 for me to play around with and see if I can get all our 2005 projects running on it. However, when I log onto the report server with SQL Management Studio 2008 there is no "Home" folder listed in Object Explorer. With our SSRS 2005 server I get a Home folder that contains a list of all our reports ...
When I try to access a 2005 database in studio 2008 I receive the debugger does not support 2005 or earlier. This is a new install, as far as I understand. Is there something that I need to turn off to disable this? ...
I have a print statement in a while loop of a stored procedure. The procedure updates around 20,000 records. The print statement should print out the primary key of each record but it does not display in the output window even though the procedure executes entirely and updates all the records. Is there some limit to the amount of data...
When I need to open a query window for a database, my tool currently opens a new instance of SQL management studio for each database. Is there a way to instead open a new tab in an existing instance? Thanks! ...
I would like to create my database tables in SMS then generate a script so C# can create the tables programmitically. I am currently hand coding each table at a time in visual studio. I think its far better to create the tables in SQL management studio then generate a script so c# can execute it latter on. Do you guys have any idea how t...
I have a very wide table, containing lots and lots of bit fields. These bit fields were originally set up as nullable. Now we've just made a decision that it doesn't make sense to have them nullable; the value is either Yes or No, default No. In other words, the schema should change from: create table MyTable( ID bigint not null, ...
I have created a simple view consisting of 3 tables in SQL. By right clicking and selecting Design, in the Object explorer table, i modified my custom view. I just added sortby asc in a field. The problem is that the changes are not reflected in the outout of the View. After saving the view, and selecting Open view the sort is not disp...
It doesn't seem like SQL Management Studio Express 2005 considers Internet Options proxy settings defined for the LAN when trying to connect to SQL Server 2005. Is there a way to make it use the proxy settings? ...
I've a user account on a development SQL express on a remote server. This account has all privileges granted to it but when I use SQL express remotely then I'm not able to make changes to tables. If I log into the virtual machine and sign in with same user I can make changes. It says I'm not database owner or system administrator. I thi...
I have a LINQ to SQL query that when executed does not return any data. However, when I debug, I can take the generated SQL query, plug in the values for the variables, and run it in SQL Management Studio to get the record I'm expecting. I'm taking the values for the variables while in debug mode as well. Has anyone experienced someth...
Hello. I'm writing some utility which performs following: creates structure for sql database creates solution + projects binds projects and solutions to TFS I'm able to recreate .ssmssln, .ssmsqlproj, .vssscc, .vspscc files, and therefore create project with binding information. Also, I add and commit those files into TFS. Howeve...
Hi. Recently I inherited a database from another programmer (created / stored with SQL Management Studio 2008), and I am having massive difficulties accessing, modifying, or even viewing the previously created databases. Specifically, when I try to load one of the databases in SQL Management Studio I get the following error message: ...