I have sql database stored on a shared netwrok drive , after set of configurations I can attach this database over the network on sql server 2008 instance. But I want to attach the same database on different machine that contains different sql instance (I think logically there is no data corruption as I want it to be reading only). So ...
Hi Due to the lack of documentation for this on MSDN, I am forced to ask here. Does the Express version support the same Change Tracking Feature(s) as the other editions does? Thanks leppie ...
I'm able to execute a stored procedure which queries a Linked Server directly, but when I call the same sproc though ASP.NET then I get the following error: Access to the remote server is denied because no login-mapping exists. When I execute it through SSMS, I am connected through my Windows domain account. The site is ASP.NET ...
Or will everything explode and kill a couple of kittens? ...
Hi folks, in a previous question i asked, the suggested answer was for me to partition my field onto another Filegroup, keeping the field in the same table. I'm not sure how to do this. I've tried to google for things like partition table, partition view, etc. Could anyone provide me with some links or some sample sql code? DB Server ...
I was reading the Maximum Capacity Specifications for SQL Server and I came across the designation of a wide table. It's different from a standard table in that is can have as many as 30,000 rows as opposed to a normal (narrow) table that is limited to the more familiar 1024 columns. I googled for wide table, but nothing seem to come up ...
The sp_password sproc in sql server 2000 only required membership in the db_accessadmin db_securityadmin database roles and membership in the securityadmin server role to allow a user to change passwords w/o knowing the old password. However in sql server 2005/2008 the BOL says a user now needs the "CONTROL SERVER" permission to do this...
What's the best way to truncate a datetime value (as to remove hours minutes and seconds) in SQL Server 2008? For example: declare @SomeDate datetime = '2009-05-28 16:30:22' select trunc_date(@SomeDate) ----------------------- 2009-05-28 00:00:00.000 Thanks ...
How can I add SQL Server 2008 Express to the list of Pre-requisites in Visual Studio 2008 SP1 MSI Installer Project. Thanks Kishore ...
I have a csv file and i need to import it to a table in sql 2005 or 2008. The column names and count in the csv are different from the table column names and count. The csv is splitted by a ';' . Example CSV FILEcontents: FirstName;LastName;Country;Age Roger;Mouthout;Belgium;55 SQL Person Table Columns: FName,LName,Country ...
I'm new to the whole RFID arena. I need to store an RFID pr asset in the database. No decision has yet been made on what system will feed that particular field (or fields?) so I just want to set aside some space right now. Oracle has this whole "Identity" package that handles, amongst other things, the different versions and types of R...
I have a live database that had some data deleted from it and I need that data back. I have a very recent copy of that database that has already been restored on another machine. Unrelated changes have been made to the live database since the backup, so I do not want to wipe out the live database with a full restore. The data I need is ...
I have the following table of TIME datatypes clarification: I am representing hours/mins/seconds of videos and want to figure out how long the videos will be. runtime ---------------- 01:27:19.0000000 01:26:09.0000000 01:00:56.0000000 01:09:59.0000000 01:25:43.0000000 01:16:01.0000000 01:27:12.0000000 01:22:00.0000000 01:17:47.0000000 ...
I'm trying to get rid of the /reports directory which seems to be integrated with SQL reporting services 2008. I'm unable to uninstall that one element of SQL server and I've had no luck when trying to reconfigure the ReportBuilderLaunchURL. Does anyone out there know how I can get rid of this stupid feature? I'd understand if it was ...
I am a .NET developer with average SQL skills. I am working on a web app that is 'database heavy'. I have been using the profiler to debug queries and procs. Is there a way to use this tool to look at performance of a query / procedure. How do I make the most of the SQL Profiler? I am using SQL Server 2008. ...
I've installed sql2008 express sp1 on my laptop that's running the beta 1 of windows 7. The problem that I'm experiencing is a combination of dynamic ports/firewall/windows 7. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify tha...
In Management Studio, you can right click on the tables group to create a filter for the table list. Has anyone figured out a way to include multiple tables in the filter? For example, I'd like all tables with "br_*" and "tbl_*" to show up. Anyone know how to do this? Thanks ...
What exactly happens when I create an index in my SQL Server 2008 DB on a VarChar column. This is obviously a text column. Will it be automatically fulltext indexed or does it create a different kind of index? ...
I'm getting ready to setup a Visual Studio Database Edition GDR R2 project with source control. Which files (if any), should be excluded from source control? ...
Hi folks, I wish to make a trigger but i'm not sure how to grab the data for whatever caused the trigger. I have a simlpe table. FooId INT PK NOT NULL IDENTITY Name VARCHAR(100) NOT NULL I wish to have a trigger so that when an UPDATE, INSERT or DELETE occurs, i then do the following. Pseduocode IF INSERT Print 'Insert' & Name...