|
|
Browse by Tags
All Tags » SQL Server 2005
-
By default this is disabled in 2005.
To reenable it run the following:
USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO
-
After installing SP1 for SQL Server 2005 SSIS Integration Services fails.
The service did not respond to the start or control request in a timely fashion.
Below is all the information you will need to fix the issue.
BE SURE TO INSTALL THE 6 HOTFIX UPDATES IN THE ORDER SPECIFIED
Links:
SQL Server 2005 SP1: ...
-
Ever have a table where you need to insert a value into an identity field.
For example - you may have a lookup table with values 2, 3, 4 - I don't know about you but it annoys me to no end when the 1 value is missing. You could truncate the table and re-insert all the values... but this is assuming there is no foreign ...
-
Create a domain user account
Set Password to Never Expires
From the webserver run the following command from the command line
aspnet_regiis -ga Domain\AccountName
In IIS - Create an application pool
Identity Tab
Cofigurable - Enter your Username and Password
Click ok then re-enter your password
Assign your website to your new ...
-
In software that I develop I have adopted a known standard for Date/Time to reduce the scope for error and the complexity of software. The standard is taken from ISO 8601.
Year: YYYY (eg 1997) Year and month: YYYY-MM (eg 1997-07) ...
-
For whatever reason when I use the formview with an inputoutput parameter I get a crazy error Cannot convert int to nvarchar...
After some investigation when checking the parameters collection it changes my return variable to a string even though it is an int 32
<asp:Parameter Direction=''InputOutput'' Name=''Variable'' Type=''Int32'' ...
-
Execute the following in the query analyzer:
-- add the linked server EXEC sp_addlinkedserver '<Reference Name>', '<Linked server type>', 'Microsoft.Jet.OLEDB.4.0', '<Full Path to DB>'
-- add the login credentialsEXEC sp_addlinkedsrvlogin '<Reference Name>', '<impersonate - true or ...
-
Execute the following in the query analyzer:
-- add the linked server EXEC sp_addlinkedserver '<Reference Name>', '<Linked server type>', 'MSDAORA', '<TNS Name>'
-- add the login credentialsEXEC sp_addlinkedsrvlogin '<Reference Name>', '<impersonate - true or false>',<Local User ...
|
|
|