SQL 2005 Reporting Services Deploy Error:
The permissions granted to user 'DOMAIN\my_name' are insufficient for performing this operation.
I have used 2000 RS and am setting up a new RS but ...
This question is as simple as it seems.
I have SQL Express 2005 on my Win2k3 SBS box. I want to create a new instance that another program can attach to. How do I do that? For MSDE, I co...
I am currently importing data back into a database after it was accidently deleted. However the source that I am importing from also contains data that still exists in the destination database...
I have a database approximately 40GB in size. The database's indexes are heavily fragmented. I would like to rebuild the indexes using the following script
ALTER INDEX ALL ON [LIVEDATABASE]...
I have a money data type field that is displaying values like this:
127.1500
How can I set all these values back to 127.15 for example (two decimal places)
I would like to know what does the value -1 indicate when I execute the command.ExecuteNonQuery which excutes a stored procedure.
iResult = command.ExecuteNonQuery
iResult shows -1
1) Using Fill method of DataAdapter, opens SqlConnection and closes it after the query is executed. While using SqlCommand, we need to explicitly open and close SqlConnection. I want the SqlCo...
I need to manually truncate and shrink a transaction log file in SQL 2005 and I do not know how can someone give me some quick steps to follow. Thanks.
When I try to capture the result set from sp_help_job using the following statement, it works fine:
INSERT dbname.dbo.tablename
EXEC [LinkedServer\Instance].msdb.dbo.sp_help_job @execution...
Try and execute the SQL below on SQL Server 2005 (use a test database as 2 stored procedures are created).
When "SecurityCheck" raises the error I need "SomeAction" to ROLLBACK TRANSACTION ...
Hi,
I am loading a file into my ETL process (using a Data Flow)
First i create a new FileInfo entry to describe the file. I want to get the FileID field back from the update.
Note: FileID i...
Hi,
I have just inherited this enviroment 2 weeks ago. and am trying to implement best practices for security. I am in the process of removing users from the sysadmin role. We are running...
Hi,
Is there any way in Transact-SQL (MSSQL 2005) to format the
output of datetime fields into Australian date format (DD/MM/YYYY)?
I have written a function to do this (see Code Snippe...
I need to reset my seed number in sql 2005 for a table. I do not want to delete the data. I did it once before, but I cant seem to remember how to do it again.
Pertaining to question
http://www.experts-exchange.com/Database/Miscellaneous/Q_22398914.html,
I would like to generate the script from C#. How can I achive this?
I know this is simple for a lot of you ... it's an Argghhh for me.
I have a two tables. One called MasterTable with the following columns:
ListNumber
Active
and a secondary ...
Hi All
I have another function which i need to migrate to sql 2005 from access 2000
Public Function Cleanfunc(caption)
If InStr(1, caption, " ", vbDatabaseCompare) > 1 Then
aSpace = R...
I've just installed SQL Server 2005 and I'm trying to get connected to it so I can play with creating/editing databases. I open up the SQL Server Management Studio but take a look at what I g...
ASP.Net 2.0
I am using a gridview wired to a detailsview to insert, update, and delete in mysoccer league schedule.
I have a niggling issue. I use a template field to display a calendar...
In the attached code how would I restate it so that I'm insertting N' variable instead of the text?
Necause of the multi languages I need the N' in front.
If i run the code below then i'll get the error returned - can anyone suggest the easiest way around this...
Thanks
Msg 116, Level 16, State 1, Line 4
Only one expression can be spe...
How I export a MDB (Access 2002) File to a MDF (SQL) File ?
Pleace... "For Dummies"
I have: VS2005, SQL Server 2000 and SQL Server 2005 (Express)
Hi there, I have a series of statements that I'm placing the value of a select statement into a variable and then running an update statement. I'm having some problems with the Warning of nul...
Excel queries (MS Query) cannot run with read-only role in SQL Server 2005. The error is "user does not have permission to run dbcc traceon". It's my understanding that this can be resovled by...
when viewing a table in SQL Express 2005 the date column of a particular table is not showing the local time. I am guessing this is the GMT or UTC time but just wanted to make sure.
The ...
