Search results for query: *

I have a straight forward BIDS developed package that performs an 'Execute T-SQL Statement' followed by a File System Task. It works fine when I run it in BIDS. I have imported the package to SQL Server as a File System package and set up an SQL Agent scheduled job to run it. The problem is...

There is a share on a seperate file server that my SQL Server machine can access. When I sign on to the SQL Server I can see the share in windows and copy files toi and from it within file explorer. However, when I browse for the drive letter assigned to the mapping from SQL Serverfor any...

I have inherited a set of Visual Studio ASP.Net pages that I have difficulty understanding. The key page is set to have a CodeBehind aspx.vb page which I understand. The aspx HTML page also has <% %> script lines that for the most part is client side code to do tasks such as set the first...

When creating a service broker queue you can specify the procedure to run when a message is received on the queue with the ACTIVATION parameter list. The default status is for it to be switched on. What is the default context for the procedure to run? You can specify EXECUTE AS but if you do...

Are full text indexes backed up in a BACKUP command? I assume the are as they can be allocated a filegroup?

If I create a snapshot database and then use it to revert the original database back to its snapshot state, does the snapshot get dropped or must I do that manually?

When creating a credential for a SQL server Agent job proxy, you can create it within Security->Credentials in the GUI and specify a name, windows login and password. In T-SQL the create credential command does not have parameters for linking a login and password to a credential name. How is...

Is there a GUI way of identifying the backup devices that make up a media set? I can see which devices are used as a media set for a database but not how a media set is defined outside of a database.

We need to import lots of data to SQL server 2005. BCP is recommended everywhere as the fastest method. Triggers and constraints are not applied by default but does it improve performance to still drop constraints and triggers during the import? Various sites talk about turning on the 'SELECT...

In SQL Server 2005 I want to prevent problems with view ownership chains. When two users create views used by a third user, I want to make sure the third user doesn't have to phone up both user 1 and user 2 to get permissions for all views under a view he needs to use. I know that in SQL...

To get performance gains out of splitting the TempDev database to a seperate disc, do you have to specify the use of the temp database explicitly on a T-SQL statement after moving tempdev to another drive or will sql server know it should use it?

You can assign a default schema to a user and you can define a schema owner. Can you also change the schema context of a connection? For example you can change a database in query session by typing USE AnotherDatabase. Is there a way you can select USE AnotherSchema within a database?

I have a table with no indexes or key constraints. If I create a unique clustered index on a table ( CREATE UNIQUE CLUSTERED INDEX Table01(Col1) ) - is it in effect just like creating a primary clustered key constraint when creating a table?

If I install SQL server 2005 with Windows selected... Will I be able to sign on as an SQL Server Login? ( i.e. on starting up you get a sign on box with 'Authentication'. Is 'SQL Server Authentication' offered and accepted? )

We have a Foxpro application sitting on a dedicated PC. A client user has a mapped connection to this PC over the network. The mapped PC has an executable that we can run on the PC but when a client computer user tries to run it, we get an error message, 'Cannot locate the Microsoft Visual...

Hi, I have a Dell Axim X50v with Windows Mobile 2003. I have set up a dial up connection via my mobile phone using infared. It works well but if I open up explorer, my hendheld attempts to dial up - even if I don't want it to. So it prevents me from looking at the pages in cache which I...

I have been messing about with an Evaluation version of SQL Server 2005 on my laptop. The evaluation period has expired and I'd like to enter a purchased code to re-activate it and use the database I created on it. Where do I set the code to re-activate the evaluation version?

I have a drop down list control inside a user control that is used as search criteria for an ASP.Net page. The user control sits on my web page and allows a user to select a value from its list of values. When a user selects a value and clicks on a submit button I want to be able display the...