-
- Cannot create db diagram
by Bill_Yeager
- 12 Replies
- Last post
by William Vaughn
- When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error:
cannot insert the value null into column "diagram_id"
I have searched the web and can't seem to find anything on this.
I just simply drag one table from my local db onto the diagram windows and try to Save it and that's what I get. I'm able to save diagrams on a networked SQL Server.
-
- I need to Give DBA full admin rights to SQL 2005 without OS windows rights, can anyone help please!!
by Sunny8
- 7 Replies
- Last post
by Sunny8
- The DBA at our location is demanding local admin (windows) right's to the box so he can function. Right now when he logs in i have given him right's to the inetpub directory, sql directory, i have set him as a sysadmin on sql2005 and gone into the http:\\localhost\reports and set him up as a system manager and under site priveledges set him as a sys admin. When he tries to login and configure the
-
- when i run SnapshotGenerationAgent.GenerateSnapshot(), it fails.
by Ariston Darmayuda
- 9 Replies
- Last post
by MariJo
- Everytime I generate the snapshot always show this error on replication monitor: Error messages: Executed as user: toshiba\snapshot_agent. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed. Then I go to SQL Server Agent tree and view Job Activity monitor, an got some steps, like this: 1. Snapsho
-
- New to SSIS and can't seem to get started off right.
by GKane
- 4 Replies
- Last post
by GKane
- I am trying to show my employer the benefits of using SQL SERVER (2005) vs. MS Access. My problem is I can't get past a something I believe to be simple.
I created a project in Business Solutions (I tried multiple times) - The idea of the project is to download a flat file from FTP, then pull the records into a table. I can get this to work without issue *IF* I execute this process by hand.
-
- SQL SELECT
by cisco0407
- 2 Replies
- Last post
by richbrownesq
- I need to grab the last three records from sql table . How would i do this
Cisco
-
- MDX Calculation Question - need to filter out a response value in overall calc
by dan english
- 2 Replies
- Last post
by dan english
- All right, I have been trying to come up with a solution for this problem, but so far I have had no luck. Maybe someone else can point me in the right direction:
I am working with some results from surveys and each respondents has a weight value related to them for each of their responses to the questions. So if respondent #1 has a weight value of 1.5 and respondent #2 has a weight value o
-
- OLEDB to Flat File Destination - Comes out in wrong order
by MrHat
- 5 Replies
- Last post
by Rafael Salas
- Hello,
My OLE DB Source is getting data from the following column types:
ID varchar(50), Name varchar(100), Date datetime, Currency char(3), Cost numeric(30,10)
My OLE DB Source outputs my information in the following order when I click Preview:
ID Name Date Currency Cost
When I connect the OLE DB Sorce to a Flat File Destination, it comes out in the wrong order.Wh
-
- Server: Msg 22029, Level 16, State 1, Line 0
by Garry Dawkins
- 1 Replies
- Last post
by Kuntal Loya - MSFT
- Hello everyone and happy new year.
This is related to a maintenance plan that pushes data from one to another continuesly and eventully backs up the database.
This is the code "
EXECUTE master.dbo.xp_sqlmaint N'-PlanID CA2CE438-C14B-442C-AB75-D2838EAA8076 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB " \\dca-05\sqldumps\weekly " -DelBkUps 3WEEKS -BkExt "B
-
- OUTER JOIN plus split? - how to?
by mtm81
- 3 Replies
- Last post
by mtm81
- Hi,
I have two tables.. one has a list of the UK postcodes.. well..it's actually the districts..
so it's the first two three or four characters (basically all UK postcodes are one or two letters.. then one or two numbers.. then a gap.. and then some more info)
So my first table has everything "before the gap" in seperate records.
My second table is full of exact postcodes
-
- SQL server 2005- hanging problem
by RBh
- 4 Replies
- Last post
by Ron D.
- SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems.
server is 64 bit, Windows 2003 R2 SP2
SQL server is MS SQL Server 2005 without any Service pack
Any ideas guys
Server stopped responding to the queries so after waitin
-
- User Tables
by djmikke
- 1 Replies
- Last post
by Jens K. Suessmeyer
- Hi, i'm a new in this, so when i create a Login form on VS 2005, i have a little trouble, i already create the db with a table called users and another called things, so the thing i wanna do is authenticate the users, for this on the table i have a 2 rows, "Users" and "password", an when in the login form i put the user an passwor i¡¯t'll be the same on the table, but when i deb
-
- Adding dll or executable
by sureshv
- 4 Replies
- Last post
by sureshv
- Is there an ability to add dll or executable to ssis
-
- SSIS Service won't start
by Paul Clancy
- 9 Replies
- Last post
by kgause
- I've been completely unsuccessful so far in getting the SSIS service to start under normal circumstances.
I've got the SQL 2005 RTM DVD and a clean, brand-new installation of
Windows 2000 Server (Service Pack 4). All system requirements have been
met according to the SQL installer. I choose to install just the
Database Engine, SSIS and the Workstation components, all other
installation op
-
- Maintaining custom colors when exporting to Excel
by Jim O
- 1 Replies
- Last post
by Priyank_Pandey
- I am using RGB HEX #s in my report for some colors. It shows up fine when rendering to a browser, however when exporting to Excel my custom colors don't come over. I've tried creating a report.xlt file with my custom colors in it, but when I export to Excel it uses the standard Excel palette instead of the custom palette in my report.xlt.
Any ideas on how to retain my custom colors when exp
-
- Need advice on how to optimize table.
by Preston M. Price
- 4 Replies
- Last post
by GlennAlanBerry
- I have a ledger table that will have many entries for a given invoice, I need a good way to identify the most recent entry for the invoice. I've thought about putting an IsMostRecent flag in the column, but it would still require a table scan to identify the most recent records for invoices. I thought I could build a view over that table that had the invoiceID and max(tableID) and build an index o
-
- ParallelPeriod: Same Day Last Month in long months
by DanSchlatter
- 2 Replies
- Last post
by DanSchlatter
- I am using the following MDX query to return same day last month values:
WITH
MEMBER [Measures].[Same Day Last Month] AS
'(ParallelPeriod([Reporting Date].[Year - Quarter - Month - Date].[Month],1),[Measures].[Active Account Indicator])'
SELECT
{[Measures].[Active Account Indicator],[Measures].[Same Day Last Month]} ON COLUMNS ,
NON EMPTY {[Reporting Date].[Date].
-
- Custom Rollup Formulas on Analysis Services 2005
by Odin_dark
- 9 Replies
- Last post
by Vasko24
- Hello all, I¡¯m a beginner on AS2005 (but I know pretty well AS2000), I migrated a cube from AS2000 to AS2005 but in this cube I have a Custom Rollup Formula on two levels of my Time dimension (month and week), an example of the week level formula is the next: iif( [Time].CurrentMember.Name = [Time].CurrentMember.NextMember.Name, null, iif( [Time].CurrentMember.Name = [Time].CurrentMember.Pre
-
- Backup Device vs backup command
by Vidhya Sagar
- 6 Replies
- Last post
by Satya SKJ
- Hi, Will backup get completed quickly (the time taken for backing up large databases) on backup device or using backup command If backup device, why
-
- Report Server First Time Configuration: Provider Load Failure
by pjtaylor
- 10 Replies
- Last post
by K9
- I'm trying to do the above using the Reporting Services Configuration Manager and I can't even connect. I get the error Provider Load Failure.
Anyone got any pointers
-
- How to step through a table, run a stored procedure on each record and update the table
by Bank5
- 5 Replies
- Last post
by Kent Waldrop Jl07
- I have a table that contains a CourseID field and a Status field. CourseID Status 1 NULL 2 NULL 3 NULL I need to loop through this table and run a stored procedure on each CourseID to fill in the status field. How can I do this I'm not a big fan of cursors and hardly ever use them, but for this case, I'm not sure if there's a way around it. I'm using SQL Server 2005 btw
-
- Combination Graphs?
by DCPan
- 2 Replies
- Last post
by DCPan
- Are combination graphs possible in reporting services
-
- import file to ntext column by textcopy.exe
by LouiseWong
- 5 Replies
- Last post
by sohst
- I have a table filetable(id int, content ntext), when I invoke textcopy.exe (c:\textcopy /S servername /U sa /P apasswd /D filedatabase /T filetable /C content /W "where file_id=1" /F c:\a.txt /I)to import file content to a table's column whose datatype is ntext, I always get error warning as follows follows:
TEXTCOPY Version 1.0 DB-Library version 8.00.2039 SQL Server 'servername'
-
- Reports prints 1 page only
by jeschr
- 4 Replies
- Last post
by larry smithmier
- I am getting an error " An error occured during printing (0x80004005)" - when i am trying to print - and the i still am able to print - but only 1 page.
Thre registry key - Reporting services was not there - so i created it at
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Reporting Services] "LogRSClientPrintInfo"=dword:00000001
Please help - w
-
- if posible use a database name in a variable?
by cgodoy
- 3 Replies
- Last post
by pons68
- I need use a variable in the next situation:
select * from @databasename ..tablename
The database name is in a .ini file.
Have any option to implement this situation
Thanks in advance
Chama
-
- Login failing for a user
by GrahamY
- 6 Replies
- Last post
by Jens K. Suessmeyer
- I have loaded my c# windows app onto a PC and I can connect to the database, when I logon as an admin I can run my app and connect to the database. However when I logon as an 'ordinary' user I can run the app but not acess the database - error: Login failed for user 'R\fred' ie '<domain>\<user>'
Obviously I need to adjust a setting somewhere, I'm just not sure where!
Help